| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Counting rows that satisfy multiple conditions
Example:
A B C 1 01/10/2009 Cancelled John, Steven 2 01/09/2009 Reported John, Steven 3 20/09/2009 Cancelled John, Darren 4 12/10/2009 Reported John, Darren, Steven 5 14/10/2009 Reported Darren, Steven How can I count the number of rows that contain month of October in column A, Reported in column B and contain John in column C - in this example the answer is 1 (row 4) Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Counting rows that meet conditions in multiple columns | Excel Worksheet Functions | |||
| Counting for multiple conditions | Excel Worksheet Functions | |||
| Excel 2003 function for counting rows with two conditions. | Excel Worksheet Functions | |||
| Help with counting multiple conditions | Excel Discussion (Misc queries) | |||
| Counting occurrences of multiple conditions | Excel Discussion (Misc queries) | |||
Threaded Mode
