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.

Im 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 doesnt 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?