Please help with a 3d formula.

C

cfspahn24

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!!
 
W

William Horton

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).
 
B

Bob Phillips

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)
 
Top