Is there a way to use a list as criteria for a countifs formula?
Example
Countifs(criteria_range1,criteria1...)
countifs(A1:A100,F1:F3)
I have a data set and I want it to count when it shows any of the 3 cells. I know I can do this with 3 countifs statements, but I was hoping I could do it with one. Doing multiple countifs could be time consuming when I have 10 or even more criteria.
________________________________________
The more questions I ask and the more I learn, I realize that I don't know squat!!!
Try
=SUMPRODUCT(COUNTIFS(A1:A100,F1:F3))
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I'm not 100% sure what =SUMPRODUCT(COUNTIFS(A1:A100,F1:F3)) did, but it didn't provide the desired result. I'm assuming that you can't put a range in the criteria1 section of the countifs statement as I did above, but I did so to illustrate what I would like to do. Is there any other type of formula that could be used to accomplish what I need?
________________________________________
The more questions I ask and the more I learn, I realize that I don't know squat!!!
Then you would best be showing us the input data and an example result, as it did what I thought you wanted.
____________________________________________
Nihil simul inventum est et perfectum
Abusus non tollit usum
Last night I dreamed of a small consolation enjoyed only by the blind: Nobody knows the trouble I've not seen!
James Thurber
I am mistaken, your method works!!! Thank you so much. I had written the formula wrong and was getting incorrect results.
________________________________________
The more questions I ask and the more I learn, I realize that I don't know squat!!!
Posting Permissions
Reply With Quote
