XL2003. I have a simple little workbook where I add six numbers to a little
column of prepared cells every month in rows 5:9, column R one month, S the
next and so on. The sixth number is the received total, so I have a check
further down that adds (say) R5:R9 and should naturally get the same answer
as that sixth one in R10. The trouble is that as soon as I tab out of that
sixth cell the check sum formula morphs to SUM(R5:R10). Why?

I catch the error here, but I'm nervous that it might happen elsewhere in a
not-so-obvious way.

Jonathan,

I am using 2002, so yours may be a bit different. But I suspect your problem
lies he

Go to Tools - Options - Edit Tab - Uncheck "Extend List Formats and
Formulas"

John

"Jonathan589" wrote:

XL2003. I have a simple little workbook where I add six numbers to a little
column of prepared cells every month in rows 5:9, column R one month, S the
next and so on. The sixth number is the received total, so I have a check
further down that adds (say) R5:R9 and should naturally get the same answer
as that sixth one in R10. The trouble is that as soon as I tab out of that
sixth cell the check sum formula morphs to SUM(R5:R10). Why?

I catch the error here, but I'm nervous that it might happen elsewhere in a
not-so-obvious way.

Thanks for this John. The XL2003 equivalent is "Extend data range formats and
formulas" and turning it off fixed my Little Problem. I will now investigate
the point of this option!

"Exceleration" wrote:

Jonathan,

I am using 2002, so yours may be a bit different. But I suspect your problem
lies he

Go to Tools - Options - Edit Tab - Uncheck "Extend List Formats and
Formulas"

John

"Jonathan589" wrote:

XL2003. I have a simple little workbook where I add six numbers to a little
column of prepared cells every month in rows 5:9, column R one month, S the
next and so on. The sixth number is the received total, so I have a check
further down that adds (say) R5:R9 and should naturally get the same answer
as that sixth one in R10. The trouble is that as soon as I tab out of that
sixth cell the check sum formula morphs to SUM(R5:R10). Why?

I catch the error here, but I'm nervous that it might happen elsewhere in a
not-so-obvious way.