Thread: COUNTA or COUNTIF or COUNT
View Single Post
  #3  
Old June 4th, 2010, 09:11 PM posted to microsoft.public.excel.worksheet.functions
Don Guillett[_2_]
external usenet poster
  
Posts: 607
Default COUNTA or COUNTIF or COUNT
=sumproduct((b3:b5="bill")*(c3:c5="yes"))

--
Don Guillett
Microsoft MVP Excel
SalesAid Software

"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