E
EricG
Let's say I have in column A a series of strings, and in Column B either
"Yes" or "No". I would like to count the number of occurrences where I have
a certain sub-string (say "XYZ") in the cell in column A, and where the cell
in column B in the same row is "No". Do this for rows 2 to 100.
I can use =COUNTIF(A2:A100,"*XYZ*") to get the first count, but I can't
figure out how to combine it with the second criterion of "No" in column B.
Is this a good time to use SUMPRODUCT, which I have yet to learn?
Thanks,
Eric
"Yes" or "No". I would like to count the number of occurrences where I have
a certain sub-string (say "XYZ") in the cell in column A, and where the cell
in column B in the same row is "No". Do this for rows 2 to 100.
I can use =COUNTIF(A2:A100,"*XYZ*") to get the first count, but I can't
figure out how to combine it with the second criterion of "No" in column B.
Is this a good time to use SUMPRODUCT, which I have yet to learn?
Thanks,
Eric