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

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

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

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

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

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