Forum Discussion

DAHAWOR1953's avatar
DAHAWOR1953
Copper Contributor
Oct 16, 2023
Solved

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 sugg...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Oct 16, 2023

    DAHAWOR1953 

    Perhaps you want

     

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

DAHAWOR1953's avatar
DAHAWOR1953
Copper Contributor
Oct 16, 2023
Thank you for the speedy reply but I am unable to change the column lengths they are populated.
HansVogelaar's avatar
HansVogelaar
MVP
Oct 16, 2023

DAHAWOR1953 

Perhaps you want

 

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

  • DAHAWOR1953's avatar
    DAHAWOR1953
    Copper Contributor
    Oct 16, 2023
    Brill - that's what I need - again many thanks for the speedy reply, really appreciated.

Resources