Total different items from one column with reference to another?

[Michael]

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

 

[CLR]

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]

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]

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]

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]

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