Median Bmi How To Get Excel To Tell You Certain Information?

How to get Excel to tell you certain information? - median bmi

I have details about 2166 people. There is a column having sex with either 1 (men) or 2 (female) for each. Other data such as age, BMI, etc. I have separated the average deviation to find median, and the level of all men and all women. How do I get Excel to give me the average of all age groups for men and women as men are included in the table?