Sum the values in a column if all the conditions are true.

## Usage

SumIf(number, condition 1, [condition 2], ...)

**number** (required) Column of numbers to add together. Null values are skipped.

**condition 1** (required) Logical condition that returns a result that is either True or False. If the condition is True, the number on the corresponding row is added to the sum.

**condition 2** (optional) Additional conditions can be added after the first condition.

## Example

SumIf( [Sales], [State] = "TX" )

- Returns the sum of all the sales in Texas.