# SUMIFS

## Content

This function adds the cells in a range using multiple criteria.

## Syntax

`SUMIFS(sum_range, criteria_range1, criteria1, [criteria_range2, criteria2], ...)`

## Arguments

This function has these arguments:

| Argument | Description |
| -------- | ----------- |
| *Sum\_range* | [Required] The range of cells to sum. |
| *Criteria\_range1* | [Required] 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. |
| *Criteria1* | [Required] 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". |
| Criteria\_range2, criteria2, … | [Optional] Additional ranges and their associated criteria. You can enter up to 127 range/criteria pairs. |

## Examples

`SUMIFS(A1:A10, B1:B10,">0",C1:C10,"<10")`