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
|