Thread: Count(if(A3:A200)="100000" if (B3:B200="Y") and (C3:C200=Z)))
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Biff
 
Posts: n/a
Default Count(if(A3:A200)="100000" if (B3:B200="Y") and (C3:C200=Z)))
Hi!

Try this:

=SUMPRODUCT(--(A3:A200=100000),--(B3:B200="Y"),--(C3:C200="Z"))

Biff

"Prasad" wrote in message
...
I find it difficult to get results for getting a formula. Please help


Reply With QuoteReply With Quote