Thanks Rowan, but I was looking for VBA code to do this.
Ciao!

"Rowan" wrote in message
...
Make sure that D1 reads =SUM(A1:C1). Hover the mouse over the bottom right
corner of the cell (D1) so that it becomes a black cross. Click and drag
down
to the bottom of your data. This will put the correct formula in each
cell.

Hope this is what you were after
Rowan

"FrigidDigit" wrote:

Hi All,

I have a looming deadline for this spreadsheet else I'd try harder to
search
for the answer myself, however, I am hoping one of you gurus can give me
a
quick answer:

I wish to check that the formulae in a sheet have not been changed by a
user
and that each cell contains the correct formula.

I have values in columns A:C and in D I have the formula =Sum(A1:C1).
This
continues down for about 250 rows.

How can I check down the D column that the formula is correct in each
cell,
taking into account the row offset change?

Thanks for any advice!

Frigid Digit