Adding up with SUMIFS

AdvancedAdvanced

12 questions, about 20 minutes

Add up with several conditions. Watch out: the arguments are in a different order from SUMIF.

What we'll do

  • Several conditions when adding up
  • The order of the arguments

What you'll use

  • SUMIFS

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
Full explanation