Administration and Executive AssistantTier 620 minintermediate

SUBTOTAL Function Numbers

Total a list of figures with SUBTOTAL, using the function number that actually means SUM.

What you will learn

• Use SUBTOTAL with function number 9 to total a range
• Explain that SUBTOTAL's first argument selects which statistic it calculates, not just that it is "a subtotal"
• Recognise that a wrong function number still returns a plausible-looking number for a different statistic entirely

Excel skills

SUBTOTAL · Reporting and Aggregation

The task

Ten stores' sales are listed. Report the total sales across all of them in Summary!B3, using SUBTOTAL.

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