help - function I think

[David Cleland]

hi,

I have a real problem - that is getting to me, ok here goes

sheet 1 lists transactions by departments

on sheet 2 I would like to be able to add up the transactions for each dept.
The problem is that the dept is column D but the amount is Column I

any ideas ?

David

[Gary''s Student]

A Pivot Table is what you want. You can use the data on sheet1 and put the
results on sheet2

If you are not familiar with Pivot Tables, see:

http://peltiertech.com/Excel/Pivots/pivotstart.htm
--
Gary's Student


"David Cleland" wrote:

> hi,
>
> I have a real problem - that is getting to me, ok here goes
>
> sheet 1 lists transactions by departments
>
> on sheet 2 I would like to be able to add up the transactions for each dept.
> The problem is that the dept is column D but the amount is Column I
>
> any ideas ?
>
> David
>
>
>

[David Cleland]

>
> If you are not familiar with Pivot Tables, see:
>
> http://peltiertech.com/Excel/Pivots/pivotstart.htm
> --
> Gary's Student

flip, I am totally lost already, is there an easier way ?

David

[Bob Phillips]

Try this then

=SUMIF(D:D,"department",I:I)

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"David Cleland" <davidjcleland@hotmail.com> wrote in message
news:eEXVTR8ZGHA.4544@TK2MSFTNGP02.phx.gbl...
>
>
> >
> > If you are not familiar with Pivot Tables, see:
> >
> > http://peltiertech.com/Excel/Pivots/pivotstart.htm
> > --
> > Gary's Student
>
> flip, I am totally lost already, is there an easier way ?
>
> David
>
>

[David Cleland]

> Try this then
>
> =SUMIF(D:D,"department",I:I)
>

thanks all I think I have the pivot table working but I am having to force
it to update each time i add a transaction ?

David

[Dave Peterson]

Sort your data by column D.

Then select your range of data and
data|subtotals
At each change in column D, use sum in column I
(if you included a header row, you'll see the names of the fields).

Then use the outlining symbols at the left to hide/show the details.

====
But if you learned about the pivottable stuff, you wouldn't have to sort your
data....

If you want to read more about pivottables...

Here are a few links:

Debra Dalgleish's pictures at Jon Peltier's site:
http://peltiertech.com/Excel/Pivots/pivottables.htm
And Debra's own site:
http://www.contextures.com/xlPivot01.html

John Walkenbach also has some at:
http://j-walk.com/ss/excel/files/general.htm
(look for Tony Gwynn's Hit Database)

Chip Pearson keeps Harald Staff's notes at:
http://www.cpearson.com/excel/pivots.htm

MS has some at (xl2000 and xl2002):
http://office.microsoft.com/downloads/2000/XCrtPiv.aspx
http://office.microsoft.com/assistan...lconPT101.aspx

David Cleland wrote:
>
> hi,
>
> I have a real problem - that is getting to me, ok here goes
>
> sheet 1 lists transactions by departments
>
> on sheet 2 I would like to be able to add up the transactions for each dept.
> The problem is that the dept is column D but the amount is Column I
>
> any ideas ?
>
> David

--

Dave Peterson