I have a simple spreadsheet where I have copied down the formula.

For example =SUM(E56+F56+G56+H56+I55)

then =SUM(E57+F57+G57+H57+I56)

but from the next line onwards I get the #VALUE! error message?! The values
are all numbers.

Any help would be great.