Excel Magic Trick 1164

Average Score After Subtracting Two Lowest: SMALL & Array or AVERAGEIF?

DESCRIPTION

See how to calculated the average for quiz scores after subtracting the two lowest
(00:08) Problem Setup
(00:22) Status Bar Trick
(00:50) Convert Data Table to Excel Table using Excel Table feature so that we can have dynamic ranges.
(01:47) SUM, SMALL & Array Constant, COUNT formula
(05:03) AVERAGEIF formula that does not calculate the correct answer when there are duplicate scores.




Be the first to comment

Leave a Reply