Forum Discussion
Need help with an Excel formula
Hi
I'm trying to figure out a formula in Excel. I don't know if this is possible but I can't
get it to work correctly for me. I have two sections in a sheet. One section is this months sales,
the other section is the grand total for the all time sales.
I tried this formula:
=SUM(J33,G18)
I put the previous grand total in J33, and the months total was in G18. Then in the cell that the formula was in it would put the grand total.
That works great once, but when I change G18 for the next months sales it removes from the
grand total. I want a way to keep adding to the grand total, and not ever removing. I want to
be able to change the months total each time.
For example:
August sales:
Total Sales: $100.00
Grand Total: $200.00
September sales:
Total Sales: $150.00
Grand Total: $350.00
Can anyone help me with this? I would really appreciate it! Thank you!
- Philip WestSteel Contributor
Why not record each months total in a seperte table? You can then very easily use that table to keep running total.