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!