Skip to content

Functions Path Playground Leaderboard Blog

fx

ABCD

1

2

3

4

5

Loading…

Free, hands-on Excel practice in a real spreadsheet. Learn by doing, not by watching.

Practice

All exercises
Start with SUM
Learning path
Playground
Keyboard shortcuts
Skills Passport
Leaderboards
Blog

Functions

SUM
IF
XLOOKUP
COUNTIF
All functions

Account

Sign in
Create free account

SheetSkill

About us
Contact us
Privacy Policy
Terms of Use

© 2026 SheetSkill · Learn. Practice. Master. · Always free.Developed by Jerin George Pallath · Not affiliated with Microsoft

DROP/Top Performer Sales Total (Excluding Best and Worst)

0 of 1285 complete

DROPAdvanced

Top Performer Sales Total (Excluding Best and Worst)

Question

In cell D8, calculate the sum of the Sales values after removing the highest and lowest sales figures using DROP combined with SORT and SUM.

Answer in cell D8

How it’s written

=DROP(array, rows, [columns])

Removes rows or columns from the start or end. Arguments in [brackets] are optional.

10 points for a first try without hints, 5 otherwise.

Practice sheetClick the dashed cell D8, type your formula, press Enter.

Loading the spreadsheet…

Check from anywhere with Ctrl + Enter