Skip to main content

aggregate_values

Function aggregate_values 

Source
pub fn aggregate_values(function_num: u32, values: &[Value]) -> Value
Expand description

Evaluates SUBTOTAL/AGGREGATE function function_num over already-filtered cell values.

Codes 1–11 (and 101–111) are AVERAGE, COUNT, COUNTA, MAX, MIN, PRODUCT, STDEV.S, STDEV.P, SUM, VAR.S, VAR.P; 12 = MEDIAN, 13 = MODE.SNGL. Codes 14–19 need k: use aggregate_values_k (they give #VALUE! here). Values that are not numbers are ignored (COUNTA counts non-empty values); the first error value present is returned.