Thanks, but that doesn't work either.
Incidentally, Column A cells may contain from 1 to 15 different letters. My
dilemma is that I'm only looking for those including "Q" (and "Claims" in
Column B).


"Don Guillett" wrote:

this will count where the cell in a is Q and the cell in b is claims

=SUMPRODUCT((A1:A100,"q")*(b1:b100="claims"))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"mckzach" wrote in message
...
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.