Need help with formula for Weekly Value

[ARTCGAL]

I created a weight loss worksheet. The columns are as follows:

Current Weight
Weekly Pounds Lost
Total Pounds Lost
Pounds to Goal

I have no problems with the formulas for the Total Pounds Lost and the
Pounds to Goal...however, the column with the Weekly Pounds Lost doesn't
change automatically each week I enter in the current weight.

I did copy the formula down...but, I don't want the values to show up until
I enter the weekly current weight numbers/column.

Here are my formulas (the current weight column I enter in the number, the
rest of the columns should update automaticaly):

Column 2 (Weekly Pounds Lost)

=SUM(D7-D8)
=SUM(D8-D9)
=SUM(D9-D10) etc...etc.

Column 3 (Total Pounds Lost)
=SUM($D$4-D8)
=SUM($D$4-D9)
etc...etc...

Column 4 (Pounds to Goal)
=SUM(D8-$D$5)
=SUM(D9-$D$5)
etc...etc...

So, what formula can I enter into the 2nd column so the values don't show up
until I enter the current weightin column 1? Right now it shows after the
first four weekly current weight values entered as:

12.0
5.0
2.0
3.0
#VALUE!
#VALUE!
0.0
0.0
0.0
0.0
etc...etc.

I hope I explained this well!

....also, if you can be patient with me...I'm not an Excel expert...just know
BASIC formulas!

Thank you for ANY help!!

[Dav]

All you want to do is make sure there is a weight entered in the row where the calcuations appear and if this is the case perform the calculations. Unless it is the row below it depends, if the weights are the end of the week so you can do the sum or they are the start of the week and you do the sum for the row above.

you need if(weight in cell,calculation,"")
so something like if(d4>0,d3-d4,"")

Regards

Dav

[Toppers]

Something like:

=IF(ISBLANK(D8),"",D7-D8)

and you not need SUM in your fotmulae; D7-D8 etc will do.

HTH

"ARTCGAL" wrote:

> I created a weight loss worksheet. The columns are as follows:
>
> Current Weight
> Weekly Pounds Lost
> Total Pounds Lost
> Pounds to Goal
>
> I have no problems with the formulas for the Total Pounds Lost and the
> Pounds to Goal...however, the column with the Weekly Pounds Lost doesn't
> change automatically each week I enter in the current weight.
>
> I did copy the formula down...but, I don't want the values to show up until
> I enter the weekly current weight numbers/column.
>
> Here are my formulas (the current weight column I enter in the number, the
> rest of the columns should update automaticaly):
>
> Column 2 (Weekly Pounds Lost)
>
> =SUM(D7-D8)
> =SUM(D8-D9)
> =SUM(D9-D10) etc...etc.
>
> Column 3 (Total Pounds Lost)
> =SUM($D$4-D8)
> =SUM($D$4-D9)
> etc...etc...
>
> Column 4 (Pounds to Goal)
> =SUM(D8-$D$5)
> =SUM(D9-$D$5)
> etc...etc...
>
> So, what formula can I enter into the 2nd column so the values don't show up
> until I enter the current weightin column 1? Right now it shows after the
> first four weekly current weight values entered as:
>
> 12.0
> 5.0
> 2.0
> 3.0
> #VALUE!
> #VALUE!
> 0.0
> 0.0
> 0.0
> 0.0
> etc...etc.
>
> I hope I explained this well!
>
> ...also, if you can be patient with me...I'm not an Excel expert...just know
> BASIC formulas!
>
> Thank you for ANY help!!

[ARTCGAL]

Thank you for your help!

"Dav" wrote:

>
> All you want to do is make sure there is a weight entered in the row
> where the calcuations appear and if this is the case perform the
> calculations. Unless it is the row below it depends, if the weights are
> the end of the week so you can do the sum or they are the start of the
> week and you do the sum for the row above.
>
> you need if(weight in cell,calculation,"")
> so something like if(d4>0,d3-d4,"")
>
> Regards
>
> Dav
>
>
> --
> Dav
> ------------------------------------------------------------------------
> Dav's Profile: http://www.excelforum.com/member.php...o&userid=27107
> View this thread: http://www.excelforum.com/showthread...hreadid=574154
>
>

[ARTCGAL]

Thank you VERY much! This works!

Also, I always forget I don't have to put in SUM...I think it is a bad habit
because when I learned Excel YEARS and YEARS ago, this is how I was taught. I
don't use Excel on a daily basis...my expertise is Illustrator, Quark,
InDesign and Photoshop! LOL!

"Toppers" wrote:

> Something like:
>
> =IF(ISBLANK(D8),"",D7-D8)
>
> and you not need SUM in your fotmulae; D7-D8 etc will do.
>
> HTH
>
> "ARTCGAL" wrote:
>
> > I created a weight loss worksheet. The columns are as follows:
> >
> > Current Weight
> > Weekly Pounds Lost
> > Total Pounds Lost
> > Pounds to Goal
> >
> > I have no problems with the formulas for the Total Pounds Lost and the
> > Pounds to Goal...however, the column with the Weekly Pounds Lost doesn't
> > change automatically each week I enter in the current weight.
> >
> > I did copy the formula down...but, I don't want the values to show up until
> > I enter the weekly current weight numbers/column.
> >
> > Here are my formulas (the current weight column I enter in the number, the
> > rest of the columns should update automaticaly):
> >
> > Column 2 (Weekly Pounds Lost)
> >
> > =SUM(D7-D8)
> > =SUM(D8-D9)
> > =SUM(D9-D10) etc...etc.
> >
> > Column 3 (Total Pounds Lost)
> > =SUM($D$4-D8)
> > =SUM($D$4-D9)
> > etc...etc...
> >
> > Column 4 (Pounds to Goal)
> > =SUM(D8-$D$5)
> > =SUM(D9-$D$5)
> > etc...etc...
> >
> > So, what formula can I enter into the 2nd column so the values don't show up
> > until I enter the current weightin column 1? Right now it shows after the
> > first four weekly current weight values entered as:
> >
> > 12.0
> > 5.0
> > 2.0
> > 3.0
> > #VALUE!
> > #VALUE!
> > 0.0
> > 0.0
> > 0.0
> > 0.0
> > etc...etc.
> >
> > I hope I explained this well!
> >
> > ...also, if you can be patient with me...I'm not an Excel expert...just know
> > BASIC formulas!
> >
> > Thank you for ANY help!!