Thread: How to COUNT in this case
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.programming
Excelenator[_43_] Excelenator[_43_] is offline
external usenet poster
  
Posts: 1
Default How to COUNT in this case

Assuming your data is in Cells A1:B9 you can use this formula

=SUMPRODUCT((A1:A9=1)*((B1:B9="a")+(B1:B9="d"))

--
Excelenato

-----------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...fo&userid=3676
View this thread: http://www.excelforum.com/showthread.php?threadid=56834

Reply With QuoteReply With Quote