+ Reply to Thread
Results 1 to 8 of 8

Running total question

  1. #1
    Registered User
    Join Date
    03-09-2017
    Location
    MD
    MS-Off Ver
    2013
    Posts
    4

    Running total question

    Whats the best way to have a running total visible on my sheet ? I add numbers to one column on a daily basis and would like an easy to see total as I go without having to manually auto-sum.

    Thanks, ...you guys are awesome !

  2. #2
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2010 (Win 7 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    8,465

    Re: Running total question

    It depends on the layout of your data ...
    Ali


    Enthusiastic self-taught user of MS Excel who's always learning!
    If anyone has helped you towards solving a problem, then you can thank them by clicking on their reputation star bottom left.

  3. #3
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    2010
    Posts
    3,179

    Re: Running total question

    Post a small sample workbook and show us where you want your running total to show.

    BSB
    Please show appreciation for those that have helped you by clicking the * at the bottom left of any of their posts.

  4. #4
    Registered User
    Join Date
    03-09-2017
    Location
    MD
    MS-Off Ver
    2013
    Posts
    4

    Re: Running total question

    So in each row, I have customer name, job name, due date and price. I would like to keep a running total of the prices that I manually enter in the price column. There are no associated formulas, I just type the prices in manually in that column. (sorry)....does that answer your question? I just need a simple running total of all items in "column F".

  5. #5
    Forum Moderator AliGW's Avatar
    Join Date
    08-10-2013
    Location
    Ipswich, England
    MS-Off Ver
    Excel 2010 (Win 7 - Work) & 2016 365 Subscription (Win 10 - Home)
    Posts
    8,465

    Re: Running total question

    Will you please attach a sample Excel workbook? We are not able to work with or manipulate a description of one.

    1. Make sure that your sample data are REPRESENTATIVE of your real data. The use of unrepresentative data is very frustrating and can lead to long delays in reaching a solution.

    2. Make sure that your desired solution is also shown (mock up the results manually).

    3. Make sure that all confidential data is removed or replaced with dummy data first (e.g. names, addresses, E-mails, etc.).

    4. Try to avoid using merged cells as they cause lots of problems.

    Unfortunately the attachment icon doesn't work at the moment, so to attach an Excel file you have to do the following: just before posting, scroll down to Go Advanced and then scroll down to Manage Attachments. Now follow the instructions at the top of that screen.

    Please pay particular attention to point 2 (above): without an idea of your intended outcomes, it is often very difficult to offer appropriate advice.

  6. #6
    Forum Expert avk's Avatar
    Join Date
    07-12-2007
    Location
    India
    MS-Off Ver
    Excel 2007 & 2003
    Posts
    1,662

    Re: Running total question

    As per your comment "simple running total". If your price in "D" column
    In "F2" formula
    Formula: copy to clipboard
    Please Login or Register  to view this content.
    copy paste down.


    avk


    If my answer (or that of other members) has helped you, please say "Thanks" by clicking the Add Reputation button at the foot of one of their posts.

    Also: if your problem is solved, please take the time to mark your thread as SOLVED by going to the top of your first post, selecting "Thread Tools" and then "Mark thread as solved".

  7. #7
    Registered User
    Join Date
    03-09-2017
    Location
    MD
    MS-Off Ver
    2013
    Posts
    4

    Re: Running total question

    see if this sample screen shot helps. I don't care where the total is displayed, as long as I don't have to keep updating it manually every time I add a new job.
    sample excel Capture.JPG

  8. #8
    Forum Expert BadlySpelledBuoy's Avatar
    Join Date
    06-14-2013
    Location
    East Sussex
    MS-Off Ver
    2010
    Posts
    3,179

    Re: Running total question

    You could put the below in cell F2 and copy down further than you need.
    Formula: copy to clipboard
    Please Login or Register  to view this content.


    Or you could turn the whole range into a table use the SUM part of that formula in column F.
    Using a table will copy the formula down automatically as you add new rows of data.

    BSB

+ Reply to Thread

Thread Information

Users Browsing this Thread

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

Tags for this Thread

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