Are the totals of each individual sheet in exactly the same cell on each
sheet?

If so, say total in D50, therefo

=SUM(Sheet1:Sheet5!D50)
--
HTH,

RD
==============================================
Please keep all correspondence within the Group, so all may benefit!
==============================================


"karatefem" wrote in message
...
I have an expense statement that has 5 worksheets (one for each potential
week of the month). I want to add a formula to the first worksheet that
adds
the totals of all the worksheets together. Anyone have a simple formula I
can
copy and paste?
r