Function Index

SumIf

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

Usage

SumIf(<number>, <condition 1 True/False>...)

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 1 (optional) Additional conditions can be added after the first condition.

Examples

SumIf( [Sales], [State] = "TX" )
  • Returns the sum of all the sales in Texas.