Hello,

I have a workbook that records shelf life performance scores. There is a worksheet for each day of the month from 10-01-10 to 10-16-10 and the sheets are named in this fashion. I've inserted a Summary sheet as the last sheet and tried to add the values in cell K32 on every sheet in cell A1 of the summary sheet. I'm using this formula:

=SUM(10-01-10:10-16-10!K32)

Every time I hit enter after entering this formula I get a pop-up window that says "Update Values: 10." Why is this happening? Does it have something to do with the way the sheets are named?

Ultimately, what I need to do is average the values between K2:K31 across all sheets, so if anyone has a better suggestion on how to do that I would be ecstatic. I hope I've given enough info.

Thanks for your help!