Question 1 of 10
=SUMIFS(C2:C6, B2:B6, "Wool")
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Animal | Animal Exterior | Number of Legs | Number of Eyes |
| 2 | Alpaca | Wool | 4 | 2 |
| 3 | Shrimp | Exoskeleton | 10 | 2 |
| 4 | Spider | Exoskeleton | 8 | 8 |
| 5 | Sheep | Wool | 4 | 2 |
| 6 | Ant | Exoskeleton | 6 | 2 |
SUMIFS Function - Free Excel Practice Online
This free, interactive exercise teaches you SUMIFS Function in Excel through 10 hands-on steps. Instead of watching a video, you type the real formula into a live spreadsheet grid and get instant feedback on every answer. It is part of the SUM Functions track and works right in your browser - no Excel install, no download, and no signup.
Practising SUMIFS Function this way builds the muscle memory that transfers straight to using Excel at work, in interviews, or for certification prep. Work through the steps above, then keep going with the next lesson to build a complete, free Excel practice course.
What you'll practice in this SUMIFS Function lesson
- The first argument of SUMIFS is the range to be summed, and all subsequent arguments are pairs of ranges and criteria. To get the total sum of legs of animals with wool exteriors, type =SUMIFS(C2:C6, B2:B6, "Wool")
- To get the total sum of legs of animals with wool exteriors AND 2 eyes, type =SUMIFS(C2:C6, B2:B6, "Wool", D2:D6, 2)
- Use SUMIFS to get the total number of eyes for animals with exoskeleton exteriors AND MORE THAN 6 legs
- SUMIFS also allows wildcard matching for text, where ? replaces one character and * replaces any number of characters. To get total sum of legs for all animals that start with "s", type=SUMIFS(C2:C6, A2:A6, "S*")
- Use SUMIFS to get total sum of legs for all animals that start with "sh"
- Use SUMIFS to get total sum of legs for all animals that start with "s" AND have more than 3 eyes
- Use SUMIFS to get total sum of legs for all animals that have 2 eyes AND MORE THAN 4 legs
- SUMIFS is not case sensitive. What would =SUMIFS(C2:C6, B2:B6, "eXOsKeLEtoN") return?
- What would =SUMIFS(C2:C6, A2:A6, "<>*p") return?
- What would =SUMIFS(C2:C6, A2:A6, "<>*p", D2:D6, " return?
SUMIFS Function practice - FAQ
How do I practice SUMIFS Function in Excel?
Open this free LogicExcel exercise and work through 10 interactive steps. You type the real formula into a live spreadsheet grid and get instant feedback on whether it is correct, plus an explanation - no Excel install and no signup needed.
Is the SUMIFS Function exercise free?
Yes. Every LogicExcel exercise is 100% free with no account required. Your progress saves automatically in your browser.
What will I learn in this SUMIFS Function lesson?
This lesson covers SUMIFS Function as part of the SUM Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.