Instructions
Learn how to use the SUMIF function in Excel to sum cells based on criteria. Complete the questions below to practice your understanding of this useful function.
Example
Use the SUMIF function to sum sales amounts for a specific region:
Questions
1. Use the SUMIF function to sum all sales amounts for the "North" region. Write the formula here:
2. Explain how you would use the SUMIF function to sum sales for multiple criteria, such as both "South" and "East" regions. Write your answer here:
Practice Exercises
Write the SUMIF formula for the following scenarios:
a. Sum all orders where the product is "Laptop".
b. Sum all sales where the salesperson is "John" and the amount is greater than $1,000.
Remember to test your formulas in Excel to see the results!
This worksheet provides a clear introduction to the SUMIF function, examples, and practical exercises to reinforce learning.