Formula Help

[vacation]

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

[David McRitchie]

=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: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"vacation" <vacation@discussions.microsoft.com> wrote in message news:0E82B321-1EA0-4CF4-81E8-063EE7FC06C5@microsoft.com...
> 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

[vacation]

Thank you!
Vacation

"David McRitchie" wrote:

> =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: http://www.mvps.org/dmcritchie/excel/excel.htm
> Search Page: http://www.mvps.org/dmcritchie/excel/search.htm
>
> "vacation" <vacation@discussions.microsoft.com> wrote in message news:0E82B321-1EA0-4CF4-81E8-063EE7FC06C5@microsoft.com...
> > 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
>
>
>