condition statements

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
=COUNTIF(A:A,"with")

--

HTH

RP
(remove nothere from the email address if mailing direct)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

I want to count occurences between 2 dates. 4
counting repeats. 8
countif = to 1
countif where condition should be met 3
Conditional Formula Words 4
Count unique values across two columns with multiple conditions 4
count & If fomula 5
if statement" desperate insight is needed!!!!!! IF,Count, DCOUNT AHHHGGGGGGG! 1

Back
Top