Sign in to submit new ideas and vote
Get Started

MAXIF, MINIF, AVGIF Formula Capability


It would help to have the IFS functionality and combined statistical functionality MAXIF, MINIF, AVGIF, MAXIFS, MINIFS, AVGIFS similar to the current SUMIF and COUNTIF.

IFS can shorten multiple nested IF statements and easier to formulate, read and understand when referencing multiple conditions.

The combined statistical functionality will match the already implemented SUMIF(s) and COUNTIF(s). This functionality will reduce the unnecessary "helper" columns or the only workaround option of using MAX(COLLECT/JOIN when columns that are not adjacent. Without the ability to UNHIDE individual columns or between a set of columns vs all the columns, this makes the design process for best user experience VERY time consuming when having to hide and unhide fields just to accommodate/update 1 field.

5 votes

Idea Submitted · Last Updated