The SUBTOTAL function
IntermediateAdvanced
10 questions, about 16 minutes
SUM includes hidden rows too. SUBTOTAL doesn't, and that saves you from wrong totals.
What we'll do
- Why SUM counts too much after filtering
- Using SUBTOTAL
What you'll use
SUBTOTALSUM
How it works
In an example you watch and don't need to fill anything in. You answer a question yourself. If it goes wrong, you get a tip, then a hint and finally the solution.
2examplesYou watch
10questionsYou do it yourself