Administration and Executive AssistantTier 920 minintermediate

DROP's Sign Convention

Average a list of transactions that has a bogus total row tacked onto the end, without touching a real transaction.

What you will learn

• Use DROP with a negative count to remove rows from the end of a range
• Explain the difference between DROP(range,1) and DROP(range,-1)
• Recognise which end of a range a stray summary row actually sits at

Excel skills

DROP · Array Formulas

The task

Eight sales are listed, followed by a "Total" row. Work out the average sale in Summary!B3, without letting the total row itself get averaged in as if it were a transaction.

You work in a real spreadsheet in your browser, and your answer is checked against hidden traps the moment you submit.

Try this lesson free