| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Sum of total from other worksheet with that meets one criteria
I am trying to figure out how to add all dollars amounts in other worksheet
under same team ID...for instance, there are 100 different team ID but there are some same Team ID. I want to add all values under the same Team ID. I don't want to sort the Team ID then do sum every time. I want to be able to type in data without having to sort it and update the function in other sheet. How do I do that? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Add up a value that meets 2 criteria | Excel Discussion (Misc queries) | |||
| Populate worksheet with data that meets date range criteria | Excel Worksheet Functions | |||
| SUM data if meets criteria | Charts and Charting in Excel | |||
| Do Nothing If Meets Criteria | Excel Discussion (Misc queries) | |||
| Max value that meets a criteria | Excel Worksheet Functions | |||
Threaded Mode
