First of all, these *are* sheets in the same workbook ... right?

Next, read this old post:

http://tinyurl.com/dhoaz

BTW, are there spaces between WEEK and the number 1?

Looks like you put *2* spaces between the name and the number in one of your
examples!

What's chances that you made that mistake when you named your sheets in the
first place?
That is, put differing spaces between the name and the number in the actual
tabs themselves.

LOOK, with this formula, the *only* thing that matters is that the first and
the last sheet match *exactly* in both the formula and the sheet tabs.

I duplicated the error you were getting by putting extra spaces between the
"week" and the number "5".

So, check everything, and try again.
--
HTH,

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




"karatefem" wrote in message
...
This is the error I am getting (I corrected a field it should have been
I22
in each sheet)

=SUM(week1:'[week5]Week 1 '!I22) #Name?

"RagDyer" wrote:

Sounds like your sheets might not be named *or* spelled exactly as it is
in
the formula!
--
Regards,

RD


--------------------------------------------------------------------------
-
Please keep all correspondence within the NewsGroup, so all may benefit
!

--------------------------------------------------------------------------
-

"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