cancel
Showing results for 
Search instead for 
Did you mean: 

Actions for basic array stats like sum, count average

I would like to see actions for basic array statistics like sum, count, min, max or average etc of the values in an array.

 

Also, conditional versions of these might be interesting too; sumifs, countifs, minifs, maxifs, averageifs.

 

 

Status: New
Comments
jbedford
Regular Visitor

+1

 

Part of this could be handled with a "Group By" function for Arrays that lets you choose which aggregations are desired for the given properties that are grouped.

 

Conditional aggregations would be great, too! This would perhaps be achievable by doing a Filter before doing the aggregation, but I think most users w/ Excel formula familiarity would expect something like countif, sumif, etc.