Question 1 of 10
Notice that the comparison operator needs to be inside quotes.
| A | B | C | D | |
|---|---|---|---|---|
| 1 | Address | City | Value (thousands) | Units |
| 2 | 123 Balboa Ave | San Diego | 400 | 1 |
| 3 | 999 Main St | San Francisco | 600 | 2 |
| 4 | 456 Ave A | Los Angeles | 450 | 1 |
| 5 | 555 La Jolla Blvd | San Diego | 650 | 4 |
| 6 | 999 Ave E | Los Angeles | 350 | 3 |
| 7 | 111 Ave A | Los Angeles | 400 | 2 |
SUMIF Function - Free Excel Practice Online
This free, interactive exercise teaches you SUMIF 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 SUMIF 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 SUMIF Function lesson
- The SUMIF function returns the sum of numbers which meet a certain criteria. To find the total value of all properties which cost less than $500,000 type =SUMIF(C2:C7, "Notice that the comparison operator needs to be inside quotes.
- If an additional range argument is added to the end, the criteria is applied to the first range, and the second range is summed. To find the total value of properties with 2 units, type =SUMIF(D2:D7, 2, C2:C7)
- Use SUMIF to find the total number of units in San Diego
- SUMIF also uses wildcard characters where ? can be one character and * can be any number of characters. To find the total value of properties on Ave A, type =SUMIF(A2:A7, "* Ave A", C2:C7)
- Now use SUMIF with wildcard matching to get the total number of units on Ave A.
- SUMIF is not case sensitive. What would =SUMIF(B:B, "sAn dIEgO", D:D) return?
- Use SUMIF to find the total number of units for properties with less than 4 units.
- Use SUMIF and wildcard matching to get the total number of units in San Francisco and San Diego.
- Use SUMIF to get the total value of properties that do NOT have 3 units
- Use SUMIF to get the total value of properties that are NOT in San Diego
SUMIF Function practice - FAQ
How do I practice SUMIF 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 SUMIF 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 SUMIF Function lesson?
This lesson covers SUMIF 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.