Formulas in Excel tables
IntermediateAdvanced
10 questions, about 17 minutes
Use column names instead of cell addresses: =SUM(Sales[Total]) and =[@Price]*[@Quantity].
What we'll do
- Referring to a whole column
- Referring to the current row
What you'll use
MAXCOUNTIFSUMIFSUMAVERAGE
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