-
All replies
-
Helpful answers
-
Oct 15, 2016 11:05 PM in response to G.J. Mullalyby Barry,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:
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 6:14 PM in response to Barryby G.J. Mullaly,Thanks for such a quick response Barry. I have not yet had a chance to apply your suggestions but I will report on the outcome when I do. In the meantime, do you know of any way to find a median in the way that the 'averageif' function does? Thanks again for all your help!
-
Oct 16, 2016 9:35 PM in response to G.J. Mullalyby Barry,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.
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

