Making an excel sheet so formulas can not be deleted in the sum total yet in
the other cells used to add up to the sum total cell a numer can be added.

I tryed locking only the cells that contain the formula under the Format
Protect tab, but the formula could still be deleted by hitting the space bar
or entering a number.

Once a sheet is protected no numbers can be added into the cells adding up
to the sum total cell.

Not a PC wise person so a answer in easy english is best.
Dan