1. =AVERAGEIF(TABLE5[GENDER], "F", TABLE5[SALARY])