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.

See Also

Was this article helpful?

Anything else?

Our customer support team is here to help.

Contact Us