Question 1 of 10
=SUMIFS(D:D, A:A, "Albany", E:E, "Brown Trout")
SUMIFS Practice - Free Excel Practice Online
This free, interactive exercise teaches you SUMIFS Practice 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 Practice 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 Practice 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 cell G2:=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 practice - FAQ
How do I practice SUMIFS Practice 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 Practice 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 Practice lesson?
This lesson covers SUMIFS Practice as part of the SUM Functions track. You practice the syntax step by step until it becomes muscle memory you can use at work.