SUMIFS function
Adds all of its arguments that meet multiple criteria.
Syntax
SUMIFS(sum_range, criteria_range1, criteria1, [criteriaRange2], [criteria2])Square brackets indicate optional arguments.
Arguments
| Argument | Required | Meaning |
|---|---|---|
| sum_range | Yes | The range of cells to sum.A1:A20 |
| criteria_range1 | Yes | The range that is tested using criteria1. criteria_range1 and criteria1 set up a search pair whereby a range is searched for specific criteria. Once items in the range are found, their corresponding values in sum_range are added.B1:B20 |
| criteria1 | Yes | The criteria that defines which cells in criteria_range1 will be added. For example, criteria can be entered as 32, ">32", B4, "apples", or "32".">10" |
| criteriaRange2 | No · repeats | Additional ranges. You can enter up to 127 range pairs.C1:C20 |
| criteria2 | No · repeats | Additional associated criteria. You can enter up to 127 criteria pairs."<20" |
Try SUMIFS
Exclude an escaped literal label
=SUMIFS(B2:B12,A2:A12,"<>"&C2)Join <> to the active wildcard criterion in C2. The two literal A?~ spellings contribute 1 and 3, so excluding them leaves 62 from the original total of 66. Ax~ remains included. Keep the label and amount ranges aligned.
Inspect the current formula
Read its written arguments or observe actual operation values in a separate local calculation. This action neither applies a draft nor grades an answer.
Read the formula, one argument at a time
Explore the written function calls and their inputs. The calculation result belongs to the complete formula.
SUMIFS · top-level call
=SUMIFS(B2:B12,A2:A12,"<>"&C2)Follow the cells behind a result
Read explicit local references and helper formulas using a separate calculation. Your draft stays in this field; the worksheet and practice checks do not change.
The worksheet runs locally. Published checks apply to the supplied example only. Native Excel and Google Sheets compatibility remain unverified.
Practice across worksheets
Build a linked lookup or conditional report, edit its source sheets and check the formula against other datasets.
Open cross-sheet formula practice →Practice a complete task
Reference and compatibility
Univer 1.0.4 / Apache-2.0. Calculation checks cover the supplied examples only. The browser worksheet does not implement every Excel feature, external service or connected data type.