Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA solution required?
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 DEFG 549.36 123456 BobCo 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 |
#2
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA solution required?
You should be able to do that with the Sumif function. Say your data table
is A1:C4, and the department numbers you want to sum by are in E1:E2. In F1, you'd enter =Sumif($C$1:$C$4,E1,$B$1:$B$4) Then you could copy the formula down to F2. Hope that helps. -- Mike Lee McKinney,TX USA "Michael" wrote: 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 DEFG 549.36 123456 BobCo 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 |
#3
Posted to microsoft.public.excel.programming
|
|||
|
|||
VBA solution required?
A pivot table will do that for you. On the data menu select Pivot Table and
follwo the wizard. Put your Departments in the left hand column and the amounts in the data section. It will automatically create all of your totals for you by department. You could also add supplier names and move things around to suit. if you want to get fancy just add an autoformat and you will get a very professional looking report... -- HTH... Jim Thomlinson "Michael" wrote: 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 DEFG 549.36 123456 BobCo 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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
odd vlookup solution required - can you rise to the challenge?! | Excel Programming | |||
looking for a solution | Excel Worksheet Functions | |||
best solution for db | Excel Programming | |||
Need a solution! | Excel Programming | |||
Solution Required to prevent #Ref! when rows deleted | Excel Worksheet Functions |