ExcelBanter - condition statements

ExcelBanter (https://www.excelbanter.com/)

- Excel Worksheet Functions (https://www.excelbanter.com/excel-worksheet-functions/)

- - condition statements (https://www.excelbanter.com/excel-worksheet-functions/22952-condition-statements.html)

Arlene

condition statements

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?

Bob Phillips

=COUNTIF(A:A,"with")

--

HTH

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

"Arlene" wrote in message
...
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?

All times are GMT +1. The time now is 02:39 PM.