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