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!!

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(d40,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

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!!

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(d40,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

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!!