Thread: COUNTA or COUNTIF or COUNT
View Single Post
  #2   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Luke M[_4_] Luke M[_4_] is offline
external usenet poster
  
Posts: 457
Default COUNTA or COUNTIF or COUNT
=SUMPRODUCT(--(C3:C5="YES"),--(B3:B5="Bill"))

--
Best Regards,

Luke M
"Liz" wrote in message
...
Trying to count the times "YES" occurs in column C3:C5 for each time
"Bill"
indicated in column B3:B5?

--
Thanks - liz


Reply With QuoteReply With Quote