Jarlisle
12-14-2010, 08:51 AM
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.
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.