Opposite of Countifs

S

Steve

I have two columns of data. One contains the number of adults per household
and the other contains the number of children. The rest of the sheet is
filled out with survey data for my thesis.

I’m using countifs and averageifs to analyze data for households that have
at least one adult and one child.

Is there a formula that returns the data that doesn’t pass the if statement?
I need to count and average the households that have less than one adult
and/or less than 1 child.

Any suggestions?
 
R

Ron Rosenfeld

I have two columns of data. One contains the number of adults per household
and the other contains the number of children. The rest of the sheet is
filled out with survey data for my thesis.

I’m using countifs and averageifs to analyze data for households that have
at least one adult and one child.

Is there a formula that returns the data that doesn’t pass the if statement?
I need to count and average the households that have less than one adult
and/or less than 1 child.

Any suggestions?

The count would simply be the count of households less the value you get in
your countifs formula above:

e.g. =COUNTA(Household)-COUNTIFS(AdultCount,">0",ChildCount,">0")

I'm not sure from your explanation what it is that you are averaging, so you'll
have to be more specific.

You might be able to use the above count formula as the divisor, and sum up
whatever it is you are interested in averaging.


--ron
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top