| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
how to count unique values in excel based on multiple criteria
I need to count and sum a worksheet of over 10,000 rows based on
multiple criteria. 1st is by the employee name, second date range, they other is product type, but for this example i doubt three is much different than two criteria's. Employee Price Qty Date Tom 69 1 14-Feb Edgar 34 1 14-Feb Tom 55 1 10-Feb David 25 1 28-Feb Edgar 59 1 1-Feb David 280 -1 20-Feb Tom 355 1 15-Feb Edgar 125 1 17-Feb Edgar 175 1 3-Feb How could I count the QTY if the employee is Edgar between 2/14 and 2/28? Any help would be greatly appriciated. Thanks |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Count of Unique values | Excel Worksheet Functions | |||
| count based on multiple date criteria | Excel Worksheet Functions | |||
| Sum Count of Single Criteria in Multiple Non-Adjacent columns | Excel Worksheet Functions | |||
| how to count unique entries with multiple condition | Excel Worksheet Functions | |||
| Returning Multiple Values Based on One Value | Excel Worksheet Functions | |||
Threaded Mode
