Averaging when certain criteria in another column is met.

[jdpro]

Hi MrExcel group

To the sheet below, I would like to add another set of stats to separate average days at fledge for males and for females (without trimming the mean). Male and female designations are in the name column. I should be able to do it as is without making a separate column for M/F differentiation right? Since the M and F are separated by spaces? Thanks for your formula suggestions as always.

 

[jdpro]

I went ahead and separated text to columns and took care of it, was just wondering if it would be something that could be done. Thanks