You can also do that as a 3D reference, as suggested, if the order of the sheets
left to right is 'Week 1', 'Week 2', 'Week 3', 'Week 4', 'Week 5'
all sheets wanted are on contiguous tabs
=SUM('Week 1':'Week 5'!I22

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"karatefem" wrote in message ...
HEY FIGURED IT OUT!!!!
=SUM(I22,'Week 2'!I22,'Week 3'!I22,'Week 4'!I22,'Week 5'!I22)

"David McRitchie" wrote:

Can't think of any if the leftmost sheetname is Sheet1 of those to be totaled
and the rightmost sheetname is Sheet50. Sometimes people use
empty sheets for the two ends just so they can insert any number of
sheets in between. You will find information about 3D references
in help i.e. SUM 3D
the topic is: Refer to the same cell or range on multiple sheets by using a 3-D reference

---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"karatefem" wrote in message ...
I tried pasting the formula in the cell I need the total to be - I2 at the
top of sheet one-, change D50 to I21 which is the same cell on each
spreadsheet that I want to add up, however it gives me an error #NAME?

Am I missing a step?
kf

"RagDyer" wrote:

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