Sorry, my error. I altered the formula due to a
misunderstanding on my part. The formula works as it was
originally given.

-----Original Message-----
Yes. The exact formula I used for the example I gave was:
=SUMPRODUCT((ISNUMBER(SEARCH("clean",A1:A5))),B1: B5=1)

-----Original Message-----
Did you overcome the wrap-around that the NG added.

--

HTH

RP
(remove nothere from the email address if mailing
direct)


"Margaret" wrote
in message
...
This returned a value of "0" (which is not correct).
Any
thoughts?

-----Original Message-----
=SUMPRODUCT(--(ISNUMBER(SEARCH("clean",A1:A100))), --
(B1:B100=1))

--

HTH

RP
(remove nothere from the email address if mailing
direct)


"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.


.



.

.