Deleting row produces #REF error

[Gianni]

I have a column with percentages.
The top number is based on the SUM
of the lower column cells. I have,

=SUM(1-F5-F6-F7)
10.00%
9.75%
0.50%

For example, I want to delete the row
containing 10.00% and have the calculation
still be correct, but I get a #REF error.
Is there some way to do this without getting
the error.

 

[Charabeuh]

hello,

Try this: =1-SUM(F5:F7)

 

[Gianni]

hello,

Try this: =1-SUM(F5:F7)

Yes,

Very nice.

Thank you