Adding up with SUMIF
IntermediateBeginner
12 questions, about 19 minutes
Add up only the amounts that meet a condition, such as the revenue of one region.
What we'll do
- Adding up with a condition
- The difference between the criteria range and the sum range
What you'll use
SUMIFDATE
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
12questionsYou do it yourself