Forum Discussion
Using COUNTIFS
It does not work on multiple criteria ranges if the second criteria_Range2 is longer than Criteria_Range 1?
=COUNTIFS(A:A43,A79,C2:C51,A79) A79 is text.
Is there a workaround?
Appreciate any suggestions, Thank you.
6 Replies
Change the ranges so that they are the same size.
- Thank you for the speedy reply but I am unable to change the column lengths they are populated.
- Many thanks for a speedy reply but I am unable to make the columns the same length.
But COUNTIFS makes no sense if the ranges have different sizes:
COUNTIFS checks whether the first cell in the first range and the corresponding cell in the second range both satisfy the conditions. If so, it adds 1 to the count.
Then it checks the second cell in the first range and the corresponding cell in the second range, etc.
If one range is smaller than the other, there is no corresponding cell for some cells in the larger range, so COUNTIFS fails.
So you must specify ranges of the same size.
