| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
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? |
|
#2
|
|||
|
|||
|
=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? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| count duplicate (or, inversely, unique) entries, but based on a condition | Excel Worksheet Functions | |||
| Nested IF statements | Excel Worksheet Functions | |||
| Condition IF | Excel Discussion (Misc queries) | |||
| Unresolved Errors in IF Statements - Errors do not show in results | Excel Worksheet Functions | |||
| Add condition to formula | Excel Worksheet Functions | |||
Linear Mode
