If you work with numbers in Excel, there's one function you must master: SUMIF. It’s simple, powerful, and one of the most searched formulas globally. Whether you’re managing sales data, budgets, or reports, SUMIF helps you add values based on conditions — no filters needed. WHAT IS THE SUMIF FUNCTION? The SUMIF function adds numbers in a range only if they meet a given condition. Syntax: =SUMIF(range, criteria, [sum_range]) - range – The cells to test against your condition- criteria – The condition to match - sum_range (optional) – The cells to actually sum (if different from range) Example 1: Add Sales Greater Than 100 Example Data: Product Sales A 120 B 80 C 150 If you need the sum of product whose sales more than 100 then the formula will be: =SUMIF(A2:B4,">100") Result: 270 (120 + 150) Example 2: Sum Based on Text Match Example Data: Product Sales ...
If you work with numbers in Excel, there's one function you must master: SUMIF. It’s simple, powerful, and one of the most searched formulas globally. Whether you’re managing sales data, budgets, or reports, SUMIF helps you add values based on conditions — no filters needed. WHAT IS THE SUMIF FUNCTION? The SUMIF function adds numbers in a range only if they meet a given condition. Syntax: =SUMIF(range, criteria, [sum_range]) - range – The cells to test against your condition- criteria – The condition to match - sum_range (optional) – The cells to actually sum (if different from range) Example 1: Add Sales Greater Than 100 Example Data: Product Sales A 120 B 80 C 150 If you need the sum of product whose sales more than 100 then the formula will be: =SUMIF(A2:B4,">100") Result: 270 (120 + 150) Example 2: Sum Based on Text Match Example Data: Product Sales ...