Cumulative worksheet totals

  • Thread starter Thread starter Doug L
  • Start date Start date
D

Doug L

I have a workbook with numerous sheets. Each sheet's
layour is exactly the same, with te exception of the
data. How can I keep a cumulative sheet?

Thanks
Doug
 
Hi Doug!

Here's the basic syntax:

=SUM(Sheet2:Sheet4!A1)

You might have something like:

=SUM('January 2003:December 2003'!A1)

Note the use of the ' where your sheet names have spaces in them.

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