average if, reference to other cells

Hi guys,

I'm trying to write a function that averages the values in a whole row only if the word "female" is also written in that row's column. For example, in the sheet attached, I want to get the average of row 2:2, but only the average of the cells that also contain "female" (row 8) in that row's column.

I have a feeling this is pretty simple, but I'm not good at excel! Any help is sooooo appreciated.

Thanks!

Haha I knew it was simple! Thanks so much!

Does this count blank cells as 0? Or not at all