98.7% Of all customers recommend us, we're so confident about our results we publish all reviews and stats
View Live Stats View ReviewsForum home » Delegate support and help forum » Microsoft Excel Training and help » vba-excel-training - Tables in Excel
vba-excel-training - Tables in Excel
Resolved · Low Priority · Version Standard
Lucy has attended:
Excel Advanced course
Tables in Excel
Is there a formula that i can use in an excel spreadsheet that will add a sum to a total creating a new total, which when you add a new sum, will add to the new total creating the next new total? As an example, if you are working out expenses on a monthly basis, but want to total the monthly expense to an added running total- i would like to know how i can create this running total.
Hope that makes sense! Thanks
RE: tables in Excel
Hi Lucy, not sure whether I'm getting the wrong end of the stick here, but you just want to create a sum formula that keeps updating itself when more is added to the range?
if you have a column of figures in column A and a total of that column in, say, A100 then the same for column B, then column C etc,
try doing a fomula similar to this:
=sum(A100:IV100) this will sum up all of your totals in row 100.
Where is your grand total figure going to be located?
Paul
Training information:
See also:
Welcome. Please choose your application (eg. Excel) and then post your question. Our Microsoft Qualified trainers will then respond within 24 hours (working days). Frequently Asked Questions
Any suggestions, questions or comments? Please post in the Improve the forum thread. |
Excel tip:Saving your Excel Spreadsheet as a CSV FileIn situations where you need to save your Excel spreadsheet as a CSV file, follow these simple steps. |