Building a 'maximumif' function

Numbers comes with an "Averageif" function but so far as I can see, no equivalent 'Maximumif', 'Minimumif' or 'Medianif' functions. I have tried to build formulas to return these values with no success (I'm new to this exercise). Any suggestions as to how to accomplish this would be much appreciated.

MacBook Pro, macOS Sierra (10.12)

Posted on Oct 15, 2016 9:40 PM

Reply
3 replies

Oct 15, 2016 11:05 PM in response to G.J. Mullaly

Hi G.J.,


Numbers doesn't support MAXIF or MINIF, but returning max and min values with conditions is possible, as can be seen in these tables displaying MAX and MIN values within each month:

User uploaded file

Details can be found here: Re: Finding min/max number within a selected date range - Please HELP!


If this doesn't fit the bill, please provide more detail regarding the "IF" and values parts of what you are attempting.

A screen shot of the table, showing the data would also be useful.


Regards,

Barry

Oct 16, 2016 9:35 PM in response to G.J. Mullaly

Hi G.J.


Like MAXIF and MINIF, Numbers does not include or support a MEDIANIF function. But the result can be obtained in the same manner. Substitute MEDIAN for MIN or MAX in the formulas included in the linked post.

User uploaded file

E2: IF(COUNTIF(Table 1::$B,$B2)<1,"",MEDIAN(OFFSET(Table 1::$A$1,MATCH($B2,Table 1::$B,0)−1,2,COUNTIF(Table 1::$B,$B2))))


Fill down to the end of column E.


Regards,

Barry

This thread has been closed by the system or the community team. You may vote for any posts you find helpful, or search the Community for additional answers.

Building a 'maximumif' function

Welcome to Apple Support Community
A forum where Apple customers help each other with their products. Get started with your Apple Account.