Excel Forum
Similar Content
Quickly See All Cells linked to a Formula or Function in Excel
Tutorial: Ill show you how to see the cells used in a formula/function in Excel and also how to tel...
Calculate Hours Worked - Day or Night Shift & Breaks in Excel
Tutorial: Single simple formula to calculate the hours worked for a day shift or night shift and inc...
Using Formulas with Tables in Excel
Tutorial: Easy way to reference data tables and make formulas within a data table. This allows you ...



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).





Got a Question? Ask it Here in the Forum.