Function: sumIf()

Returns the sum of a set of numbers on the condition that all the values are either null or valid Numbers, a type error will be thrown if any of the values are non-numeric.

...

Returns the sum of the numbers in list above i.e. 10 + 2 + 3 + 3.3 = 18.3

sumIf([10, 2, _NULL, 3.3])

Returns the sum of the numbers in list above and will ignore empty values i.e. 10 + 2 + 3.3 = 15.3

sumIf([10, 2, "a", 3.3])

Returns a type error as the value '"a' " is not a numeric value

sumIf(in.invoiceAmount)

...