Creating MEDIANIF and MEDIANIFS in Numbers '09

Does anyone know how to create a MEDIANIF or MEDIANIFS similar to the available functions AVERAGEIF or AVERAGEIFS.

I would like to take the median price of homes built on or after 1970, but there is no function: MEDIANIFS(SOLDPRICE, Year,">=1970") like there is for AVERAGEIFS.

Thanks--

MacBook, Mac OS X (10.6.2)

Posted on Jan 1, 2010 4:24 PM

Reply
3 replies

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.

Creating MEDIANIF and MEDIANIFS in Numbers '09

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