| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
How do I count If for these special distinctions
I need to count the number of names in a very long list
complaring excel columns that are titles name and date. I would like the formula to count all DISTINCT names on EACH given date giving me a grand total of names. EXAMPLE James Smith June 12, 2004 James Smith June 12, 2004 Mike Black June 12, 2004 Karen Jones June 13, 2004 Mike Black June 13, 2004 Jane Smith June 13, 2004 Total Count: 5 I appreciate the help. Thank you. |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| filter and count | Excel Discussion (Misc queries) | |||
| Count occurences between dates | Excel Worksheet Functions | |||
| Count If Formula | Excel Worksheet Functions | |||
| How can I use count function in excel where I have several criter. | Excel Worksheet Functions | |||
| count based on two fields - need quickly | Excel Worksheet Functions | |||
Threaded Mode
