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