+ Reply to Thread
Results 1 to 5 of 5

Formula that will address the changes in each cell reflected on bottom of worksheet

  1. #1
    Registered User
    Join Date
    10-24-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9

    Formula that will address the changes in each cell reflected on bottom of worksheet

    Hello all, i am trying to figure out how to write a formula in a ws. i will try to explain what i am attempting to do, I have my base formula as follows. =sum(b2-c2-d2+e2) then since this is a monthly sheet i start the formula in b3 as =(f2) so that the amounts tally up for the next day. I drag the corner down to the next cell to carry over the formula, my question is this.....since the work sheet is long how do i write a formula that will address the changes in each cell that will reflect on bottom of worksheet? I am attempting to keep a running tally in column b34 to reflect the numbers changing above. sorry for the long question, i know this is likely a simple formula....but i am stumped.
    Michael

  2. #2
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,318

    Re: Formula that will address the changes in each cell reflected on bottom of worksheet

    Hi Michael,

    Please attach a sample workbook. Make sure there is just enough data to make it clear what is needed. Include BEFORE/AFTER sheets if needed to show the process you're trying to complete or automate. Remember to desensitize the data.

    Click on GO ADVANCED and use the paperclip icon to open the upload window.

    View Pic
    HTH
    Regards, Jeff

  3. #3
    Registered User
    Join Date
    10-24-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Formula that will address the changes in each cell reflected on bottom of worksheet

    Hello, here is the attachment (i hope). thanks
    Michael
    Attached Files Attached Files

  4. #4
    Forum Moderator jeffreybrown's Avatar
    Join Date
    02-19-2009
    Location
    Cibolo, TX
    MS-Off Ver
    Office 365
    Posts
    10,318

    Re: Formula that will address the changes in each cell reflected on bottom of worksheet

    As long as you have dates in column A, try...

    =SUM(B$2:INDEX(B:B,MATCH(9.99999999999999E+307,$A:$A)))

    Now as you add more data and rows, this formula will adjust to find the last filled row in column A, but will sum column B (B2 until the last filled cell)
    Attached Files Attached Files

  5. #5
    Registered User
    Join Date
    10-24-2011
    Location
    Florida
    MS-Off Ver
    Excel 2003
    Posts
    9

    Re: Formula that will address the changes in each cell reflected on bottom of worksheet

    Thanks for the reply Jeff, it looks like it is trying to add the numbers from column "b", i need it to reflect what is in say "b12",B13 and so on with a running tally. Notice that each day is less. Sorry for any confusion in my post, but with the page being a little long i was just trying to be able to see at the bottom the total fuel left on board without scrolling back to the top. again thanks for your help.
    Michael

+ 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