how can I create a formula in numbers to calculate the median value of a column X considering only a filtered population in the column Y?

your best bet is to make three additional columns which only include A, B, or C arm data then you can perform operations on those columns.

Assuming your data is like this:

Make the first row be a header row and

the last two rows be footer rows

Make the header in cells C1, C2, and C3 like shown above

You can make the "YA", "YB", and "YC" like this:

C2=IF($A2=RIGHT(C$1, 1), $B2, "")

this is shorthand for... select cell C2, then type (or copy and paste from here) the formula:

=IF($A2=RIGHT(C$1, 1), $B2, "")

select cell C2, copy

select cells C2 thru E11 (or the last NON-footer row of your table), paste

C12=MEDIAN(C)

C13=AVERAGE(C)

select cells C12 and C13, copy

select cells C12 thru E13, paste

inghi wrote:

hope developers will fix soon the missing formula in the new version!

As far as I know no major spreadsheet application has a MEDIANIF type function. In Excel you can create a one-cell "array" formula. But Numbers doesn't support array formulas. So you need the extra columns/cells as Wayne has demonstrated.

To leave a suggestion for Apple you can go to Numbers > Provide Numbers Feedback in your menu.

SG

I didn't have a problem. I am answering your question within the capabilities of Numbers. As SG points out can can post feedback to Apple using the menu item "Numbers > Provide Numbers Feedback"

Personally, I do not consider this a missing features since a simple combination of built-in features allows me to achieve a desired outcome.