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?