Forum Discussion
Excel
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
I used a third column saying if(B1="Yes",A1,"")
then I took the median of column C
see the attached file
Thank you very much!