How to Use the SUMIF Function in Excel (Conditional Total Made Easy)

How to Use the SUMIF Function in Excel (Conditional Total Made Easy)

The SUMIF() function is perfect when you want to sum values only if a certain condition is met. It's widely used in sales, student performance, inventory, and other business data.

📘 Syntax:

=SUMIF(range, criteria, [sum_range])

✅ Example 1 – Sum Sales for a Product:

=SUMIF(A2:A10, "Apples", B2:B10)

This adds all values in B2:B10 where the corresponding A2:A10 value is "Apples".

🎯 Common Use Cases:

• Sum total marks of only "Passed" students
• Calculate sales for one specific product or category
• Total expenses under a particular type

💡 Pro Tip:

Use wildcards like "Pen*" in criteria to match partial text.

🧠 Why Use SUMIF:

It keeps your data dynamic and avoids using filters manually. It’s a must for dashboards and summaries.

Use Excel like a pro. Learn formulas like SUMIF with ScriptDataInsights daily to grow your skillset!