I'm trying to find how many times four specific numbers are used together in
each row. My formula is as follows:

=COUNTIF(AND(B2:F964,"2","19","35","41")))

I can not figure out what I have wrong.

change this to suit
=SUMPRODUCT((B3:B11={98,99})*1)

--
Don Guillett
SalesAid Software

"lccubb" wrote in message
...
I'm trying to find how many times four specific numbers are used together
in
each row. My formula is as follows:

=COUNTIF(AND(B2:F964,"2","19","35","41")))

I can not figure out what I have wrong.

=SUM(COUNTIF(B2:F964,{"2","19","35","41"}))

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)


"lccubb" wrote in message
...
I'm trying to find how many times four specific numbers are used together
in
each row. My formula is as follows:

=COUNTIF(AND(B2:F964,"2","19","35","41")))

I can not figure out what I have wrong.