Keep formual intact after deleting a line
 

My formula reads =sum(a5+f5+g5+l5)*0.75. This represents items I want to tax
out of a larger range of items. I want to be able to delete one or more of
those lines (like af and g5) and still have the formula produce a result, not
REF! Is this possible?
Thank you

Keep formual intact after deleting a line
 

Hi

Don't delete - use Clear Contents instead

Arvi Laanemets


"vacation" wrote in message
...
My formula reads =sum(a5+f5+g5+l5)*0.75. This represents items I want to
tax
out of a larger range of items. I want to be able to delete one or more of
those lines (like af and g5) and still have the formula produce a result,
not
REF! Is this possible?
Thank you