Thread: Counting total for multiple criteria
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Excelenator Excelenator is offline
external usenet poster
  
Posts: 1
Default Counting total for multiple criteria

Say your codes are in Cells A1:A25 and the results are in B1:B25 you can
use SumProduct to count the successess and failures. The formula is

Sumproduct(($A$1:$A$25="PE")*($B$1:$B$25="Y"))

Copy the formula and change the codes and results (Y/N) to get any
combination you want.


--
Excelenator


------------------------------------------------------------------------
Excelenator's Profile: http://www.excelforum.com/member.php...o&userid=36768
View this thread: http://www.excelforum.com/showthread...hreadid=574191

Reply With QuoteReply With Quote