| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Count based on criteria
I have a spreadsheet with 8000 rows.
In column "I" I have text. eg. "Emily", "Greg" and "John" In Column "D" I have numbers. I need to count the rows whe Column I is equal to Emily and Column D is < 30 Column I is equal to Greg and Column D is < 50 Column I is equal to John and Column D is < 70 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count based on two criteria. | Excel Worksheet Functions | |||
| Count based on two different criteria | Excel Worksheet Functions | |||
| COUNT based on 2 criteria | Excel Worksheet Functions | |||
| Count based on criteria | Excel Discussion (Misc queries) | |||
| Count or Sum based on more than 1 criteria | Excel Worksheet Functions | |||
Threaded Mode
