New Formula and New date

[mtg300]

I want to build a simple sit-ups log, I have it almost done. The problem I am having is this, lets say my goal for May 8th is 300 sit-ups. I enter my goal at 300, then let say I do 50, and then 150. Now it will show me that I did 200 sit-ups and I have 100 remaining. Everything is fine until I add the next date, all the formulas are on top, and I have to reenter all the formulas again. Or whatt do I do?

How do I rearrange or set this up better?

Every time I add a new date I want to be able to have the formulas to calculate the total sit-ups done and how many sit-ups are remaining for that day.

[mtg300]

Any ideas?

[ConneXionLost]

Hi & Welcome!

First, remove your total from row 9.

In cell D2 insert this formula:

Please Login or Register  to view this content.

then autofill down.

Cheers,

[arthurbr]

Any ideas?

Hi mtg and welcome to the board

We usually ask to wait 24 hrs before bumping a question. Could you please be so kind to wait a little longer in the future?

Thanks in advance

[mtg300]

Hi & Welcome!

First, remove your total from row 9.

In cell D2 insert this formula:

Please Login or Register  to view this content.

then autofill down.

Cheers,

OK so far so good. Thanks for the help. But I run into 2 problems, the autofill leaves a running number, and second some of the autofills have green triangles on them. How can I leave a blank instead of the last number and how do I ignore the green triangle for the entire row.

Thanks Again,
MTG

[ConneXionLost]

Convert the formula to:

Please Login or Register  to view this content.

That should take care of the "running number".

The green triangle is an auto-check feature for potential errors in formulas. In this case, there's no error, so you can safely select the cells and (using the caution arrow in the upper left corner of the selected cell) tell Excel to "Ignore Error".

Cheers,