+ Reply to Thread
Results 1 to 6 of 6

New Formula and New date

  1. #1
    Registered User
    Join Date
    05-08-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Wink New Formula and New date

    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.
    Attached Files Attached Files
    Last edited by mtg300; 05-09-2011 at 12:37 AM.

  2. #2
    Registered User
    Join Date
    05-08-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: New Formula and New date

    Any ideas?

  3. #3
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: New Formula and New date

    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,
    Would you like to say thanks? Please click the: " Add Reputation" button, on the grey bar below the post.

  4. #4
    Forum Expert
    Join Date
    12-23-2006
    Location
    germany
    MS-Off Ver
    XL2003 / 2007 / 2010
    Posts
    6,325

    Re: New Formula and New date

    Quote Originally Posted by mtg300 View Post
    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

  5. #5
    Registered User
    Join Date
    05-08-2011
    Location
    USA
    MS-Off Ver
    Excel 2007
    Posts
    3

    Re: New Formula and New date

    Quote Originally Posted by ConneXionLost View Post
    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
    Attached Files Attached Files

  6. #6
    Forum Expert ConneXionLost's Avatar
    Join Date
    03-11-2009
    Location
    Victoria, Canada
    MS-Off Ver
    2010
    Posts
    2,952

    Re: New Formula and New date

    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,

+ Reply to Thread

Thread Information

Users Browsing this Thread

There are currently 1 users browsing this thread. (0 members and 1 guests)

Bookmarks

Posting Permissions

  • You may not post new threads
  • You may not post replies
  • You may not post attachments
  • You may not edit your posts

Search Engine Friendly URLs by vBSEO 3.6.0 RC 1