Download Files:

Start File:
https://excelisfun.net/files/EMT1396-97.xlsx

See how to:

1. (00:13) Introduction. What is a Running Total or Cumulative Frequency. What is a % Running Total
2. (03:10) Example 1: Grouping Integer Values for # of Transactions with a Quantity between an Lower & Upper Value
3. (04:25) Frequency (Count Function)
4. (05:20) Show Values As: Running Total, Cumulative Frequency
5. (05:49) Show Values As: % Running Total, % Cumulative Frequency
6. (06:40) Example 2: Grouping Dates to calculate Month Totals
7. (07:35) Add Revenue for Each Month
8. (08:41) Show Values As: Running Revenue Total, Cumulative Revenue Total for each Month in each Year
9. (09:36) Show Values As: % Running Total, % Cumulative Frequency for Month Totals within each year
10. (10:20) Summary

Reference Videos:
Excel Magic Trick 1396: PivotTable Show Values As: Running Total and % of Running Total (2 Examples)
Excel Magic Trick 1397: Excel Count Formulas for Running Total and % of Running Total & Ogive Chart
Excel Magic Trick 1397 Part 2: Formulas: Monthly Revenue, Running Total & % Running Total & Chart
Excel Magic Trick 1397 Part 3: % Frequency Running Total Formula w Irregular Increments & X-Y Scatter
Excel Magic Trick 1398: DAX Formulas for Running Total and % of Running Total & other DAX Tricks