Question 1 of 10
=SUMIFS(D:D, A:A, "Albany", E:E, "Brown Trout")
SUMIFS - Free Excel Practice Online
SUMIFS adds numbers that meet several conditions at once. With the same New York trout data as the SUMIF exercise, you total the brown trout in one river, the rainbow trout in one county, and then combine a wildcard name (any body of water that ends in Lake, Pond or Creek) with a county.
Every formula is the range to add first, then pairs of a range and a condition. The pairing is the point of the lesson: once you see it, adding a third condition is just one more pair at the end.
What you'll practice in this SUMIFS lesson
- For the SUMIFS function, the first argument is the range of numbers to be summed, and the remaining arguments are all pairs of cell ranges and criteria. For example, to find the total number of Brown Trout in Albany county, try typing the following formula into the formula bar:=SUMIFS(D:D, A:A, "Albany", E:E, "Brown Trout")
- Find the total number of Brown Trout in Genesee River.
- Find the total number of Rainbow Trout in Broome county.
- You decide you only like fishing in lakes, so you want to find the total number of Brown Trout in any body of water that ends in the word "Lake." Hint: Body of water should be equal to "*Lake".
- Find the total number of Brown Trout in any body of water that ends in the word "Lake" in Albany county.
- Find the total number of Brown Trout in any body of water that ends in the word "Pond". Round to the nearest whole trout.
- Find the total number of Brown Trout in any body of water that ends in the word "Creek" in Broome county. Round to the nearest whole trout.
- Find the total number of Rainbow Trout in any body of water that ends in the word "Lake" in Clinton county. Round to the nearest whole trout.
- Genegantslet Creek spans two towns, Greene and Smithville. Find the total number of trout in Genegantslet Creek in Greene.
- Genegantslet Creek spans two towns, Greene and Smithville. Find the total number of trout in Genegantslet Creek in Smithville.
SUMIFS practice - FAQ
How do I practice SUMIFS 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 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 lesson?
This lesson covers SUMIFS as part of the SUM Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.
What is the difference between SUMIF and SUMIFS?
SUMIF takes one condition and puts the range to add last. SUMIFS puts the range to add first and then takes as many range and condition pairs as you need, which is why this lesson can combine a county with a lake name in a single formula.