Forum Discussion
How to COUNTIFS with mixed criteria
I am having some issues with using the COUNTIFS function. My spreadsheet has all the readers enrolled in my reading challenges for June, sorted by age. I need to be able to quickly calculate how ma...
Mensamom We can't download or copy your file but you may try-
=COUNTIFS(Avid!$A$2:$A$500,">=19")+COUNTIFS(Avid!$A$2:$A$500,"21+")
- I fixed the permissions on the file, so you should be able to access it now.
- Your formula worked to isolate the 19+ Adults from the list, but it did not parse for those who did log reading vs. those who did not (Column I). If I add a third criterion (AVID!$I$2:$I$500,">0"), I think that would correctly identify my subset. Do you concur?