Pro lesson · 5 exercises · first one free
Multiply and add in one step: SUMPRODUCT
About this lesson
Total revenue, weighted averages, and sums with several conditions, without helper columns.
Errors and conditions · 5 short exercises in a live spreadsheet: you type each formula yourself and answer questions that make you predict results or spot bugs. Every answer is checked instantly.
What you'll practise
- Multiplying two columns and adding the results
- Calculating a weighted average
- Summing products that meet a condition
- Counting rows that meet two conditions
- Understanding the double minus trick
Functions you'll use
Try the first exercise free
Type the formula in a real spreadsheet and get instant feedback. Exercise 1 of 5, no account needed.
Pro lesson
Unlock the whole lesson
Pro unlocks every lesson, the case studies and unlimited weak-spot review. The fundamentals track stays free.