Thread: a countif statement with multiple conditions
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.misc
Don Guillett Don Guillett is offline
external usenet poster
  
Posts: 10,124
Default a countif statement with multiple conditions

try
=sumproduct((a2:a22="ace")*(b2:b22={"club","diamon d","spade"}))
--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"perfect_one1" wrote in message
...
countif cell a=ace and cell b=club, diamond, or spade. this is in a very
large spreadsheet


Reply With QuoteReply With Quote