MAXIF, MINIF, AVGIF Formula Capability

Trang Nguyen

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.

Robyn Pindell

I second this!!!!!!!!!! It's so needed!