Forum Discussion
luna155
Aug 19, 2020Copper Contributor
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
PMF_EXCEL
Aug 21, 2020Copper Contributor
certainly possible if you use a "sumproduct" search on web sommeproduct + median best PMF_EXCEL