Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Counting for two criteria - brain drain
Any help would be greatly appreciated.
I need to count the number of dates in column C for each rep (column A) for each Equipment type (column C). A B C Rep Eqp Date 1 a 31-Jan 2 b 31-Jan 1 a 1-Feb 2 a result should be Rep one has 2 Rep two has -0- for equipment type a. Thanks, Steve |
#2
|
|||
|
|||
Steve
look at SUMPRODUCT Regards Trevor "seve" wrote in message oups.com... Any help would be greatly appreciated. I need to count the number of dates in column C for each rep (column A) for each Equipment type (column C). A B C Rep Eqp Date 1 a 31-Jan 2 b 31-Jan 1 a 1-Feb 2 a result should be Rep one has 2 Rep two has -0- for equipment type a. Thanks, Steve |
#3
|
|||
|
|||
Easiest would be to use a Pivot table. Max 30 sec. to do.
Mark all values incl. headlines Data 'Pivot Table and Pivot Table Charts' Click Finish Drag and drop the first two to Row Drag and drop the last to Data Done! If it doesn't say Count, doubbleclick on Pivottable button. Ola |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Counting Cells with multiple criteria.One criteria supporting wild | Excel Worksheet Functions | |||
2 Criteria Counting | Excel Worksheet Functions | |||
Counting rows based on criteria in multiple cells | Excel Discussion (Misc queries) | |||
counting with a criteria in multiple transactions | Excel Worksheet Functions | |||
Counting "rows", i.e. simultaneous criteria for multiple cells | Excel Worksheet Functions |