calculate median value

From this example table (Sample.xlsx), I need to calculate. Calculate the median of Sales by sex. Calculate the median of Sales by sex for customers whose State is CI. Calculate the median of Sal...