To calculate the Average age of students in a table range of A$1$:J$500,$ if they are female, when Gender is located in column C$,$ and age is located in column D which of the following formulas would be correct.

A$=$AVERAGEIF$($C$1$:C$500,"$F$",$ D$1$:D$500)$B$=$AVERAGEIF$($D$1$:D$500,"$F$",$ C$1$:C$500)$C$=$AVERAGEIF$($A$1$:J$500,"$F$",$ C$1$:C$500)$