Ask Your Question

Revision history [back]

click to hide/show revision 1
initial version

Since V5.2 (first released week 31, 2016; see here) there are implemented the functions MAXIFS() and MINIFS(). Unfortunately there are not yet (V5.4.3) the respective offline help texts. You need to resort to the function wizard to be guided. (This actually is clear enough.)
(The mentioned functions are not yet specified in "OpenFormula". They were introduced for better compatibility with recent versions of MS-Excel and are expected to work in the same way as SUMIFS and AVERAGEIFS concerning the conditions given as a pair of a range and a criterion each, while the range to get the data from is given as the first parameter.)