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