Excel Magic Trick 1397

Excel Count Formulas for Running Total and % of Running Total & Ogive Chart

DESCRIPTION

See how to create formulas and a chart for Category Totals, Running Totals, and % Running Totals:
(00:15) Introduction. Why you might use formula rather than a PivotTable.
(02:00) Create formulas for Lower and Upper Limits
(03:23) Text Formula for Category Label
(04:15) COUNTIFS function to get Frequency Count
(07:23) FREQUENCY Array Function to get Frequency Count
(09:55) SUM function and expandable range for Running Total, Cumulative Frequency
(11:10) % Running Total, % Cumulative Frequency Formula
(11:55) Ogive Chart using a Line Chart and Error Bars
(18:42) Summary

WORKBOOKS

Download “Excel Magic Trick 1391-1400” Excel-Magic-Trick-1391-1400.zip – Downloaded 95 times – 3 MB







1 Comment

Leave a Reply