One way is to Concatenate the two into a third column and then do a count
on that column for the combination you wish.
Vaya con Dios,
Chuck, CABGx3
"Margaret" wrote in message
...
I need to count the number of rows where cell A includes
a specific text string AND cell B equals a specific
number. I am having trouble finding a working solution.
Example
Column A Column B
Jim cleaned 1
Bob paints 1
Cleanup, Sue's 2
Jim swept 1
Cleaning by Joe 1
I want to count the rows where Column A contains the
text "clean" AND the value in Column B is 1. Correct
answer from example above would be 2.
Thanks in advance for any suggestions.
|