Thread: COUNTA or COUNTIF or COUNT
View Single Post
  #5   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_] Don Guillett[_2_] is offline
external usenet poster
  
Posts: 1,522
Default COUNTA or COUNTIF or COUNT
xl2007

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"Steve" wrote in message
...
Try
=COUNTIFS(C3:C5,"YES",B3:B5,"Bill")

Regards
Steve

"Liz" wrote:

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