Adding across worksheets

[Guest]

The work book I am using has 6 worksheets. The first five are speparate
transactions. The last page is a summary worksheet of the the first five. I
want to add cell D5 from each transaction worksheet and have the sum show on
summary page. Can you help me with the formula?

Thanks!

 

[Nick Hodge]

Just enter and = sign on the summary sheet and click each cell you want to
add

or enter a formula like so

=SUM(Sheet5:Sheet1!D5)

Where Sheet5 to Sheet 1 are contiguous sheets in order



--
HTH
Nick Hodge
Microsoft MVP - Excel
Southampton, England
(e-mail address removed)

 

[Gord Dibben]

In a cell on Summary worksheet.

=Sum(Sheet1:Sheet5!D5)

If your first 5 sheets aren't neatly named Sheet1, 2 etc.

Insert a dummy sheet before first sheet then a dummy sheet before Summary
sheet. Name them start and end.

=SUM(start:end!D5)



Gord Dibben Excel MVP