| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total different items from one column with reference to another?
Hi;
I would like to know if there is a way to total items from one column from different dept. numbers in another column. I will try to give an example below: Supplier Name Total Cost Dept. # Acme 146.35 123456 ABC 1245.56 897654 Acme 549.36 123456 ABC 29.87 897654 I would like it to add all the totals from each department and have it list below the same spreadsheet something like below: Dept # 123456 $ 659.71 897654 $ 1275.43 I hope I have explained properly what I am looking for, and appreciate any help! Mike |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| SUMPRODUCT to count items with duplicates where another column contains two defined items | Excel Worksheet Functions | |||
| Total Items Per Hour | Excel Discussion (Misc queries) | |||
| How do I get the total number of items that meet 2 criteria in Exc | Excel Worksheet Functions | |||
| How to total like items | Excel Discussion (Misc queries) | |||
| How can I show the total sum of items in a filtered column | Excel Worksheet Functions | |||
Threaded Mode
