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