Excel Magic Trick #172: Running Total Formula or Pivot Table

See how to create a Running Total with a Formula or a Pivot Table.
For formulas, the trick is to use the SUM function and lock one of the cells, but not the other. For example: =SUM(C$13:C13).
For Pivot Tables, the trick is to add the field to the Values (or Data) area, and then right click, point to "Value Field Settings", then click on the "Show values as" tab, then select "Running total" from the "Show values as" drop down arrow, then select the "Base field" (the field in the Row area).

Category:

Science & Technology

Tags:

• Excel
• Running
• Total
• with
• Formula
• or
• Pivot
• Table
• Show
• values
• as
• Mike
• Gel
• Girvin
• Highline
• Community
• College

[Rrracket]

big help, thanks. Do you have a video showing how to create charts?

[ExcelIsFun]

Excel Basics #16: Chart Basics - Excel Charts

or

Excel Basics #16: Chart Basics - Excel Charts

[delafoo]

Sweet! Thanks!

[ExcelIsFun]

You are welcome!

[ExcelIsFun]

Woo Hoo!!

[delafoo]

@ExcelIsFun Woah... you saved me a few hours with the link to the workbook! Woo hooo! You ROCK!

[ExcelIsFun]

You can use the Excel Table feature. Try this video;

Highline Excel Class 15: Excel 2007 Tables 7 Examples

Or you can use an IF formula like in this video:

Excel Magic Trick #233: 2 Business Math Tricks

[delafoo]

Is there an easier way to have one column auto sum the data in another column without having to continuously drag the formula down? like a continuous sum function? I would like a last column that does a running total of column A, but one that I do not constantly need to drag the sum function down with.  suggestions? ( use it as a check register, would be a little less work to drag each time I update my totals).

[neatpleats]

Thanks

"I have no idea how to use a Mac.

If you have a specific question about a button works in PC but not a MAC, try this site:

mrexcel[dot]com/forum

They should know."

[ExcelIsFun]

I have no idea how to use a Mac.

If you have a specific question about a button works in PC but not a MAC, try this site:

mrexcel[dot]com/forum

They should know.