Sum the values in a column if all the conditions are true.
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.
SumIf( [Sales], [State] = "TX" )
- Returns the sum of all the sales in Texas.