Excel SUMIFS Formula
Learn how to use the SUMIFS formula in Excel to sum values based on one or more conditions.
Syntax
Copy formula manually
=SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2], [criteria2])
Example
=SUMIFS(C:C, A:A, "Finance")
Try This Formula Online
Paste sample CSV data below and test how this formula works directly in your browser.
Result
65000
SUMIFS adds numbers from a selected range when one or more conditions are met. It is commonly used for sales analysis, department-wise totals, finance reports, inventory summaries, and business dashboards.
Formula Examples
| Input | Formula | Output |
|---|---|---|
| Department = Finance | =SUMIFS(C:C, A:A, "Finance") | Total salary or value for Finance rows |
| Region = North and Product = Laptop | =SUMIFS(D:D, A:A, "North", B:B, "Laptop") | Total sales for laptops in North region |