#REF error
 

When using a formula to pull all h24 cells from each worksheet i am getting a
#REF error. This is the formula =INDIRECT("'SHEET"&ROWS($A$2:$A3)&"'!h24").
Is there a better formula? How can I correct this error?? Any help would be
greatly appreciated!!!

I don't understand exactly what you're trying to do.

If you have sheets 1 to 10, when you say "pull", do you mean *display each*
sheets content of H24 down a column, one cell per sheet?

=INDIRECT("'SHEET"&ROW(A1)&"'!H24")

And copy down for 10 rows, one for each sheet.

OR
Do you mean total (add) all the H24 cells from each sheet and display it in
a single cell:

=SUM(Sheet1:Sheet10!H24)

--
HTH,

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


"Todd Nelson" wrote in message
...
When using a formula to pull all h24 cells from each worksheet i am
getting a
#REF error. This is the formula
=INDIRECT("'SHEET"&ROWS($A$2:$A3)&"'!h24").
Is there a better formula? How can I correct this error?? Any help would
be
greatly appreciated!!!

This looks for sheet names like: sheet2, sheet3, sheet4, ...

Are those the names of your worksheets?

Todd Nelson wrote:

When using a formula to pull all h24 cells from each worksheet i am getting a
#REF error. This is the formula =INDIRECT("'SHEET"&ROWS($A$2:$A3)&"'!h24").
Is there a better formula? How can I correct this error?? Any help would be
greatly appreciated!!!

--

Dave Peterson