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...
Using Formulas with Tables in Excel
Tutorial: Easy way to reference data tables and make formulas within a data table. This allows you ...
Naming Cells in Excel to Make Using Formulas/Functions Easier
Tutorial: In this tutorial I am going to introduce the idea of Named Cells. A Named Cell is a cell w...



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.