Thread: count
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bondi
 
Posts: n/a
Default count
Hi Mike,

One way would be to use SumProduct()

=SUMPRODUCT(--(A1:A10="Y"),--(B1:B10=2))

Regards,
Bondi

Reply With QuoteReply With Quote