Please help with a 3d formula.
 

I have 30 worksheets in a workbook. I must total cell U125 on each sheet to
a summary sheet. When I do ths, the formula is exactly right, but for some
reason it is skipping the value on sheet 11. Any suggestions on what is
happening? I'm at my wit's end!!

Please help with a 3d formula.
 

What is your formula?

"cfspahn24" wrote:

I have 30 worksheets in a workbook. I must total cell U125 on each sheet to
a summary sheet. When I do ths, the formula is exactly right, but for some
reason it is skipping the value on sheet 11. Any suggestions on what is
happening? I'm at my wit's end!!

Please help with a 3d formula.
 

Is your formula like the following?
=SUM(Sheet1:Sheet30!U125)
If so are sheets 1 - 30 all in a row with no other sheets inbetween?
Could cell U125 on sheet 11 have something strange in it? Check the data
type (format). Perhaps a number is in the cell but it is formatted as text
(so that it really is text).

"cfspahn24" wrote:

I have 30 worksheets in a workbook. I must total cell U125 on each sheet to
a summary sheet. When I do ths, the formula is exactly right, but for some
reason it is skipping the value on sheet 11. Any suggestions on what is
happening? I'm at my wit's end!!

Please help with a 3d formula.
 

=SUM('Apr 1:April 30'!U125) It is skipping the sheet titled April 11.

"Duke Carey" wrote:

What is your formula?

"cfspahn24" wrote:

I have 30 worksheets in a workbook. I must total cell U125 on each sheet to
a summary sheet. When I do ths, the formula is exactly right, but for some
reason it is skipping the value on sheet 11. Any suggestions on what is
happening? I'm at my wit's end!!

Please help with a 3d formula.
 

Could it be that Apr 11 is not situated between sheets Apr 1 and April 30?

--
HTH

Bob Phillips

(remove nothere from email address if mailing direct)

"cfspahn24" wrote in message
...
=SUM('Apr 1:April 30'!U125) It is skipping the sheet titled April 11.

"Duke Carey" wrote:

What is your formula?

"cfspahn24" wrote:

I have 30 worksheets in a workbook. I must total cell U125 on each
sheet to
a summary sheet. When I do ths, the formula is exactly right, but for
some
reason it is skipping the value on sheet 11. Any suggestions on what
is
happening? I'm at my wit's end!!