VBA solution required?

Thread view:

Enable EMail Alerts

Start New Thread

Thread rating:

Michael - 24 Jan 2008 16:41 GMT

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 to this Message

mikelee101 - 24 Jan 2008 17:27 GMT

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.

Signature

Mike Lee
McKinney,TX USA

> Hi;
> > > > > > I would like to know if there is a way to total items from one column from
[quoted text clipped - 17 lines]
> > > > > >
> > > > > > Mike

Reply to this Message

Jim Thomlinson - 24 Jan 2008 17:37 GMT

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...

Signature

HTH...

Jim Thomlinson

> Hi;
> > > > > > I would like to know if there is a way to total items from one column from
[quoted text clipped - 17 lines]
> > > > > >
> > > > > > Mike

Reply to this Message