SUMIF Function in Excel
Learn how to use the SUMIF function in Excel, understand the syntax and common use cases, and let ExcelGPT adapt the formula to your real workbook structure.
SUMIF(range, criteria, [sum_range])rangeRequiredThe cells to evaluate against the condition.
criteriaRequiredThe condition to apply, such as a text value or comparison operator.
sum_rangeOptionalOptional range to sum when different from the criteria range.
Examples
=SUMIF(C:C, "Closed Won", F:F)Adds revenue from column F only when the status in column C is Closed Won.
=SUMIF(B:B, ">1000", D:D)Adds values in column D for rows where column B is greater than 1000.
Common mistakes
Check the argument order, data types, and references used in SUMIF.
Review whether ranges, blank cells, error values, or dynamic results are affecting the formula.
Validate the formula on a few sample rows before scaling it across the workbook.
Related functions
Need a variant of this formula?
Describe your workbook structure and ExcelGPT can generate a version tailored to your real columns, ranges, and edge cases.