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 !
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 !
It depends on the layout of your data ...
Ali
Enthusiastic self-taught user of MS Excel who's always learning!
Don't forget to say "thank you" in your thread to anyone who has offered you help.
You can reward them by clicking on * Add Reputation below their user name on the left, if you wish.
Forum Rules (updated August 2023): please read them here.
Post a small sample workbook and show us where you want your running total to show.
BSB
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".
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.
As per your comment "simple running total". If your price in "D" column
In "F2" formula
copy paste down.Formula:Please Login or Register to view this content.
atul
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".
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
You could put the below in cell F2 and copy down further than you need.
Formula: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
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks