Do you have a data table where you need to pick all the highest, lowest, best, worst, or equal to 2? SUMIF, and its bigger brother SUMIFS formulas can help sum cells of your choice.

## Syntax

## Steps

- Type
**=SUMIF(** - Select or type
**range**reference that you want to apply the criteria against**$E$3:$E$10** - Type criteria (alternatively
**cell**reference which contains can be used)**"FL"** - Select or type
**range**reference that includes cells to add**$H$3:$H$10** - Type
**)**and press**Enter**to complete formula

**Note**: When using SUMIFS, follow steps according to syntax of SUMIFS.

=SUMIF($E$3:$E$10,"FL",$H$3:$H$10)

=SUMIFS($H$3:$H$10,$E$3:$E$10,"FL")

## How

Both functions can be used to sum cells that meet a criteria. They search a given criteria in a criteria range, this processes result is an array of TRUE/FALSE. For example; searching **FL** value in **$E$3:$E$10** range returns {**TRUE**, FALSE, FALSE, **TRUE**, FALSE, **TRUE**, **TRUE**, **TRUE**}. And then TRUE/FALSE array is matched with array of values in sum range which is {**$48,972**, $38,828, $81,662, **$44,000**, $72,000, **$87,633**, **$80,850**, **$80,784**}. Sum of match values gives the result we need (**$342,239**).

However; syntax is slightly different between formulas. Although; **SUMIFS** function’s criteria based arguments come after sum range to be able to handle multiple criteria, to use **SUMIFS** for single criteria is completely safe and preferable.