Thread
:
COUNTA or COUNTIF or COUNT
View Single Post
#
2
June 4th, 2010, 09:09 PM posted to microsoft.public.excel.worksheet.functions
Luke M[_4_]
external usenet poster
Posts: 451
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
Luke M[_4_]
View Public Profile
View message headers
Find all posts by Luke M[_4_]
Find all threads started by Luke M[_4_]