software

Is there a way to delete line items in a worksheet and still have the formula
produce a correct result? Ex: If I delete d1 then my forumal says REF!
=sum(a1 b1 d1 f1 g1)*0.7 Different lines need to be deleted at different
times and must remain in their same location if used.
Thank you

=SUM(A1:G1)
if you eliminate the ends you would be in trouble unless you can add empty
columns to surround the data. Sum will not have a problem with empty cells.

Please use your name in newsgroups, it certain is important to use a
consistent unique name and a valid email address, if you want to get the
most out of newsgroups..
---
HTH,
David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
Search Page: www.mvps.org/dmcritchie/excel/search.htm

quot;vacationquot; gt; wrote in message ...
gt; Is there a way to delete line items in a worksheet and still have the formula
gt; produce a correct result? Ex: If I delete d1 then my forumal says REF!
gt; =sum(a1 b1 d1 f1 g1)*0.7 Different lines need to be deleted at different
gt; times and must remain in their same location if used.
gt; Thank you
Thank you!
Vacation

quot;David McRitchiequot; wrote:

gt; =SUM(A1:G1)
gt; if you eliminate the ends you would be in trouble unless you can add empty
gt; columns to surround the data. Sum will not have a problem with empty cells.
gt;
gt; Please use your name in newsgroups, it certain is important to use a
gt; consistent unique name and a valid email address, if you want to get the
gt; most out of newsgroups..
gt; ---
gt; HTH,
gt; David McRitchie, Microsoft MVP - Excel [site changed Nov. 2001]
gt; My Excel Pages: www.mvps.org/dmcritchie/excel/excel.htm
gt; Search Page: www.mvps.org/dmcritchie/excel/search.htm
gt;
gt; quot;vacationquot; gt; wrote in message ...
gt; gt; Is there a way to delete line items in a worksheet and still have the formula
gt; gt; produce a correct result? Ex: If I delete d1 then my forumal says REF!
gt; gt; =sum(a1 b1 d1 f1 g1)*0.7 Different lines need to be deleted at different
gt; gt; times and must remain in their same location if used.
gt; gt; Thank you
gt;
gt;
gt;