Sure =Sum(B5:B212). By the way, this is a shared workbook.

"Trevor Shuttleworth" wrote:

Might help if you include the formulae that you are using.

Regards

Trevor


"mac849" wrote in message
...
I have 5 formulas in a worksheet that refer to a range. When data is
entered
in the range, the formulas adjust to exclude the cells with data. Range
B5:B211 When data is entered in B5, range in the formulas becomes
B6:B212.
The workbook has nearly 200 worksheets with the same formulas. I'm
working
in Excel 2003. Does anybody have any idea what's going on?????