Download Files:

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

https://excelisfun.net/files/EMT1397%20Part%2002.xlsx

https://excelisfun.net/files/EMT1397%20Part%2003.xlsx

See how to create a formula for % Running Total when the Increments are Irregular. Also see how to create an X-Y Scatter “Ogive” or % Cumulative Frequency Chart:

1. (00:14) Introduction.
2. (01:29) COUNTIFS & COUNT formula for % Cumulative Frequency or % Running Total for Counting
3. (04:36) X Y Scatter Chart for Ogive Chart or % Cumulative Frequency Chart
4. (11:54) 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 1398: DAX Formulas for Running Total and % of Running Total & other DAX Tricks