# How to Show a Running Total on Excel Worksheet

Video duration: 2:38

To see the running total in each row of an Excel table, you can use the SUM function.

The total should include all the amounts from the first cell down to the current row. To lock the starting position for the SUM function, you can use an absolute reference to the starting row.

Then, leave the ending position as a relative reference, so it will adjust automatically, when you copy the formula down the column.

Instructor: Debra Dalgleish, Contextures Inc.
Get Debra’s weekly Excel tips:…

## 21 thoughts on “How to Show a Running Total on Excel Worksheet”

#### Bruce Simpson

(July 29, 2018 - 11:22 pm)

Yes, super helpful for sure! But one thing I can't figure out is when I do it, why I end up with green triangles in the upper left corner all the way down Column D? I understand those triangles have to do with an incorrect formula, but the running total worked fine. So those triangles are a mystery to me??

#### Tapan kumar Panda

(July 29, 2018 - 11:22 pm)

Thank you so much… Very helpful videos

#### Janeshwar Singh

(July 29, 2018 - 11:22 pm)

Thank you 👍

#### Anil Shah

(July 29, 2018 - 11:22 pm)

If last balance of of account is 880000 as on April 2018 how much amount will be received in retirement time may 2018 please reply

#### Anil Shah

(July 29, 2018 - 11:22 pm)

If last balance April 2018 in of account how much total amount at the time of retirement will be received in may 2018 please revert

#### Lily Rose

(July 29, 2018 - 11:22 pm)

What a wonderful time-saving hint. Thank you so much!

#### Trish Schmidt

(July 29, 2018 - 11:22 pm)

Wow ! Straight to the point! Thank you! Please make some more of these videos lady!

#### pbrown0209

(July 29, 2018 - 11:22 pm)

I have tried many websites, but this was the best! Thanks!!

#### benqsi

(July 29, 2018 - 11:22 pm)

#### John Ballinger

(July 29, 2018 - 11:22 pm)

THANK YOU!!!!

#### Melanzane

(July 29, 2018 - 11:22 pm)

You must be using an old version of Excel. Clicking the button in the lower right of a cell does not 'copy down' in Excel 2016.

#### Andy Leigh

(July 29, 2018 - 11:22 pm)

#### SajoieDeVie

(July 29, 2018 - 11:22 pm)

Thank you. It became easy for me to figure out as soon as I saw you do it.

#### Aiqimusic

(July 29, 2018 - 11:22 pm)

thank you, finally something that is easy to follow for a first time excel user, much appreciated

#### NicholasAthias

(July 29, 2018 - 11:22 pm)

Thank You,I learnt something new.

#### malia_lehua

(July 29, 2018 - 11:22 pm)

This was perfect help for me, thank you very much

#### wewex7

(July 29, 2018 - 11:22 pm)

This is the best tip ever!!!! Thanks.

#### Amanda Kulp

(July 29, 2018 - 11:22 pm)

Thank you very much! This really helped me for my homework. 😀

#### Desmond L

(July 29, 2018 - 11:22 pm)

Thanks this has been alot of help with what I do at work. much appreciated.

#### ZMBP

(July 29, 2018 - 11:22 pm)

Excellent tip and I just followed along and changed one of my excel spreadsheets for which I had been doing the running total the hard way – with a calculator. Thank you.

#### krn14242

(July 29, 2018 - 11:22 pm)

Great tip thanks Debra