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

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

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