Explainry Tutorials to Expert in IT

Calculate running total in Excel

Do these steps for the running total:

1- Go to a blank cell which should directly above or below/ right or left the range that you want to sum with running total

then press “Alt + =” buttons.

2- After pressing Enter button, Excel will automatically sum the nearby ranges like in our example.

3- Press F2 to edit the formula.

From the formula, select B3 and press F4.

After pressing F4, $ will appear with B3.

6- Press Enter for the result.

5- Copy and drag down the formula.

Copyright © 2016 - 2020 Explainry.com | All Rights Reserved