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 |
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total different items from one column with reference to another?
You can "roll your own" with the SUMIF formula, or you might take a look at the
Data SubTotals feature Vaya con Dios, Chuck, CABGx3 "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 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 |
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total different items from one column with reference to anothe
Thanks for the quick response CLR. I currently use the subtotals feature but
want the results placed below the spreadsheet as a "Summary". I don't think I can use the SUMIF as I don't know what departments might be charging and there could be multiple (usually are) entries from the same departments. Thanks again! "CLR" wrote: You can "roll your own" with the SUMIF formula, or you might take a look at the Data SubTotals feature Vaya con Dios, Chuck, CABGx3 "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 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 |
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total different items from one column with reference to anothe
OK then, sounds like a job for a Pivot Table.......
Drag the Supp;lier and Dept to the left side, and the SumOfCost to the data field. Vaya con Dios, Chcuk, CABGx3 "Michael" wrote: Thanks for the quick response CLR. I currently use the subtotals feature but want the results placed below the spreadsheet as a "Summary". I don't think I can use the SUMIF as I don't know what departments might be charging and there could be multiple (usually are) entries from the same departments. Thanks again! "CLR" wrote: You can "roll your own" with the SUMIF formula, or you might take a look at the Data SubTotals feature Vaya con Dios, Chuck, CABGx3 "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 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 |
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total different items from one column with reference to anothe
Thanks again CLR,
Is there any possible way that I can achieve what I originally suggested without using a pivot table? I am trying to make this sheet a template I can fill in monthly and also print out the results and summaries. I was hoping to create something a little more automated rather than setting up the data ranges and so forth every month as the amount of charges every month can be from 5 -200. Thanks again, Mike "CLR" wrote: OK then, sounds like a job for a Pivot Table....... Drag the Supp;lier and Dept to the left side, and the SumOfCost to the data field. Vaya con Dios, Chcuk, CABGx3 "Michael" wrote: Thanks for the quick response CLR. I currently use the subtotals feature but want the results placed below the spreadsheet as a "Summary". I don't think I can use the SUMIF as I don't know what departments might be charging and there could be multiple (usually are) entries from the same departments. Thanks again! "CLR" wrote: You can "roll your own" with the SUMIF formula, or you might take a look at the Data SubTotals feature Vaya con Dios, Chuck, CABGx3 "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 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 |
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
Total different items from one column with reference to anothe
Yes, with VBA. A custom program can be written to do as you describe. If
you do seek a VBA solution, I suggest you get your details all together and re-post in the Programming Group Vaya con Dios, Chuck, CABGx3 "Michael" wrote: Thanks again CLR, Is there any possible way that I can achieve what I originally suggested without using a pivot table? I am trying to make this sheet a template I can fill in monthly and also print out the results and summaries. I was hoping to create something a little more automated rather than setting up the data ranges and so forth every month as the amount of charges every month can be from 5 -200. Thanks again, Mike "CLR" wrote: OK then, sounds like a job for a Pivot Table....... Drag the Supp;lier and Dept to the left side, and the SumOfCost to the data field. Vaya con Dios, Chcuk, CABGx3 "Michael" wrote: Thanks for the quick response CLR. I currently use the subtotals feature but want the results placed below the spreadsheet as a "Summary". I don't think I can use the SUMIF as I don't know what departments might be charging and there could be multiple (usually are) entries from the same departments. Thanks again! "CLR" wrote: You can "roll your own" with the SUMIF formula, or you might take a look at the Data SubTotals feature Vaya con Dios, Chuck, CABGx3 "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 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 |
Reply |
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 |