Thread: Counting using OR?
View Single Post
  #3   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Bernd Bernd is offline
external usenet poster
  
Posts: 92
Default Counting using OR?
Hi Aaron,

A general approach to apply OR criteria in sumproducts is IMHO
=SUMPRODUCT(SIGN((A1:A8="Y")+(B1:B8="Y")))

Regards,
Bernd

Reply With QuoteReply With Quote