PDA

View Full Version : Solved: Countifs Help



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.

Bob Phillips
12-14-2010, 09:06 AM
Try

=SUMPRODUCT(COUNTIFS(A1:A100,F1:F3))

Jarlisle
12-14-2010, 01:17 PM
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?

Bob Phillips
12-14-2010, 02:27 PM
Then you would best be showing us the input data and an example result, as it did what I thought you wanted.

Jarlisle
12-14-2010, 03:51 PM
I am mistaken, your method works!!! Thank you so much. I had written the formula wrong and was getting incorrect results.