View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
lccubb lccubb is offline
external usenet poster
 
Posts: 7
Default 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.