Forum Discussion

Selby Johnson's avatar
Selby Johnson
Copper Contributor
Aug 06, 2018

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 West's avatar
    Philip West
    Steel Contributor

    Why not record each months total in a seperte table? You can then very easily use that table to keep  running total.

Resources