COUNTIF(AND Statement
 

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.

COUNTIF(AND Statement
 

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.

COUNTIF(AND Statement
 

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