Using COUNTIFS

[DAHAWOR1953]

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.

[#2]

@DAHAWOR1953 

Change the ranges so that they are the same size.

[#3]

Many thanks for a speedy reply but I am unable to make the columns the same length.

[#4]

Thank you for the speedy reply but I am unable to change the column lengths they are populated.

[#5]

@DAHAWOR1953 

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.

[#6 · Accepted solution]

@DAHAWOR1953 

Perhaps you want

=COUNTIF(A2:A43,A79)+COUNTIF(C2:C51,A79)

[#7]

Brill - that's what I need - again many thanks for the speedy reply, really appreciated.