Generalize MINIF and MAXIF to be SMALLIF and LARGEIF
The new conditional MIN and MAX formulae are great. Conditionalizing SMALL and LARGE would take this to the next level. A conditional version of SMALL based on the ordinary tool-set is very cumbersome.
Kenneth Barber commented
I don't think that we need more functions that are variations of existing functions (see my comment at the link below).
Rather than making a variation of each aggregate function (sum, count, min, max, average, small, large, stdevp, varp, median, mode, ...), we should have single function that filters for the desired values before we apply the aggregate function. This is what I was doing for in my post below.
The idea is this: have 2 new functions ARRAYAND and ARRAYOR that can combine the criteria into a Boolean array. Based on this array, a new function FILTER can return an array of only the values that meet those criteria. Then use a regular aggregate function (SUM, COUNT, AVERAGE, ...) on the returned array.