condition statements

A

Arlene

I have a spread sheetlike
week type name
1 with John
2 bill
4 over tim
2 with pete

I need to caculate/count the number of people in week 1 that are type "with"
How do I do that besides sorting? If or count or productsum?
 
B

Bob Phillips

=COUNTIF(A:A,"with")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
Top