I've got a sheet of about 500 entries. This sheet contains 4-letter words in one column, a corresponding number to this row, and a corresponding gender. I need to make a function that finds all rows with the same 4-letter word, then gets a number for males, as well as a number for females. These numbers will then be calculated to an average for males, and a average for females.

Any suggestions? :)

Doesn't have to be one formula for both genders; it can (actually would prefer it to be) one formula for each gender.

`COUNTIFS`

function, however it's difficult to tell anything more without knowing your sample data. – Máté Juhász Aug 7 '18 at 7:42