M
mckzach
Greetings,
I need to count up the number of occurrences of the letter "Q" in Column A,
only if the string in Column B = "Claims."
That is, how do I combine . . .
=SUMPRODUCT(LEN(A1:A100)-LEN(SUBSTITUTE(A1:A100,"Q","")))
AND
=COUNTIF(B1:B100,"Claims")
I have tried various approaches and different formulas, but nothing seems to
work. Any help at all would be appreciated. Thanks in advance.
I need to count up the number of occurrences of the letter "Q" in Column A,
only if the string in Column B = "Claims."
That is, how do I combine . . .
=SUMPRODUCT(LEN(A1:A100)-LEN(SUBSTITUTE(A1:A100,"Q","")))
AND
=COUNTIF(B1:B100,"Claims")
I have tried various approaches and different formulas, but nothing seems to
work. Any help at all would be appreciated. Thanks in advance.