Conditional Statistical Functions operate much like statistical aggregation functions, except that the last argument is a constraint expression that NExS evaluates for each cell in the argument list. Only cells that meet constraint criteria are included in the calculation. The constraint expression may be any NExS expression that evaluates to a numeric result.
Conditional Statistical Functions return a numeric value.
For more information on constraint expressions, please see Chapter 6, Calculations.