View Single Post
  #4  
Old June 4th, 2010, 09:18 PM posted to microsoft.public.excel.worksheet.functions
Steve
external usenet poster
 
Posts: 2,662
Default 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