SUMIF

The SUMIF function can be used to return the sum of values in a list if they meet a certain criterion.

Syntax

sumif( list, condition)

Arguments

list – The input list of values on which the filter is to be applied

condition – The condition to be evaluated

Return value

Returns the sum of values.

Example

sumif([Sales,Sales1,Sales2],">0.1m")

Returns the sum of values in Sales, Sales1, and Sales2 if they are greater than 0.1m.

SUMIF to calculate the total sales