working out sums over a number of sheets

[Mark]

I use excel for my invoices, the way I do this is to have one template
invoice sheet and a file for each business year, within this book I insert
the template whenever I add an invoice, what I want to do is have one sheet
in each book called total and this sheet adds the overall values for each
invoice within that one book, so when my business year is over I have one
number of all my earnings for that year on the total sheet. the cell which
the total for each invoice is on is F,65. Is there a way of doing this or am
I missing something, it seems to me to be a very easy thing to want to do.

Thanks for any help given

Mark

 

[Frank Kabel]

Hi
try
=SUM('Sheet1:Sheet20'!F65)

 

[Gord Dibben]

Mark

If your sheets have unique names unlike Sheet1, 2, 3 etc. insert a dummy blank
sheet at beginning and name it Start and another at end and name it End.

Use Frank's formula and amend to =SUM('Start:End'!F65) which will pick up all
sheets between.

Gord Dibben Excel MVP

 

[Norman Harker]

Hi Mark!

No need to post the same question to different groups.

--
Regards
Norman Harker MVP (Excel)
Sydney, Australia
(e-mail address removed)
Excel and Word Function Lists (Classifications, Syntax and Arguments)
available free to good homes.