Excel

[luna155]

Hi. I have two columns A and B. I would like to calculate the median of the data in A only if it in B says "Yes". Can anybody help my with the command for this? Thanks 

[#2]

@luna155 

I used a third column saying if(B1="Yes",A1,"")

then I took the median of column C

see the attached file

[#3]

@luna155 

As variant

=MEDIAN(IF(B:B="Yes",A:A))

using as it is on Excel with dynamic arrays or entered as array formula by Ctrl+Shift+Enter in other case.

[#4]

Thank you very much - was a great help! 
@Sergei Baklan 

[#5]

Thank you very much!

[#6]

certainly possible if you use a "sumproduct" search on web sommeproduct + median best PMF_EXCEL