Look Who it Was Random video

Excel Magic Trick 1164: Average Score After Subtracting Two Lowest: SMALL & Array or AVEAGEIF?

3,436 views · Published 4 December 2014 · 7:51 · Indexed 12 November 2026

Channel: excelisfun · 2014 · Education

Watch on YouTube

Download Excel Start File: https://excelisfun.net/files/EMT1163-1165.xlsx

Download File: https://excelisfun.net/
See how to calculated the average for quiz scores after subtracting the two lowest
1. (00:08 minute mark) Problem Setup
2. (00:22 minute mark) Status Bar Trick
3. (00:50 minuet mark) Convert Data Table to Excel Table using Excel Table feature so that we can have dynamic ranges.
4. (01:47 minute mark) SUM, SMALL & Array Constant, COUNT formula 
5. (05:03 minute mark) AVEAGEIF formula that does not calculate the correct answer when there are duplicate scores.

More from this channel