COUNTIF(AND Statement

L

lccubb

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

Bob Phillips

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

--
---
HTH

Bob

(change the xxxx to gmail if mailing direct)
 
Top