Question 1 of 10
The SUMIF function has three arguments: the criteria range and the criteria, and the optional third argument is the range to be summed. Type this into the formula bar:
=SUMIF(B:B, "Westerlo", D:D)
Enter the resulting total number of trout in Westerlo into the field below to check your answer.
SUMIF - Free Excel Practice Online
SUMIF adds up only the numbers that meet a condition. This exercise gives you a table of trout populations in bodies of water across New York and a fishing trip to plan, starting from the town of Westerlo and widening to the rainbow trout in the whole state.
The later steps add wildcard matching, so one formula can total every creek, and then ask for rivers, ponds and the town of Aurora. You practise the three parts of SUMIF (the range to check, the condition and the range to add) until choosing them becomes automatic.
What you'll practice in this SUMIF lesson
- The table below shows trout populations in different bodies of water in New York. You're planning a trip to Westerlo, New York, and as an avid trout enthusiast you want to know the total number of trout in the town. The SUMIF function has three arguments: the criteria range and the criteria, and the optional third argument is the range to be summed. Type this into the formula bar: =SUMIF(B:B, "Westerlo", D:D)Enter the resulting total number of trout in Westerlo into the field below to check your answer.
- You know you may not stay in Westerlo for your whole trip, so you're interested in the trout totals for the entire county. Modify your SUMIF formula to count the number of trout when the county is "Albany". Enter the resulting total into the field below.
- Now you're only interested in rainbow trout and want to know how many rainbow trout are in all of New York. Find the sum when species name is "Rainbow Trout" (round to the nearest whole trout)
- How many trout are in Allen Lake?
- You decide you only want to fish in creeks. Use wildcard matching to find the total number of trout in bodies of water that end in "Creek". Hint: Waterbody name is equal to "*Creek".
- How many trout are in rivers?
- How many trout are in ponds (round to the nearest whole trout)?
- How many trout are in the town of Aurora?
- How many trout are in Erie county?
- How many trout are in Ten Mile River?
SUMIF practice - FAQ
How do I practice SUMIF 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 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 lesson?
This lesson covers SUMIF as part of the SUM Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.
How do wildcards work in SUMIF?
An asterisk stands for any text, so "*Creek" matches every name that ends in Creek and "Lake*" every name that starts with Lake. This lesson uses it to total all the creeks at once, and you can use the same idea for rivers and ponds.