Try,
=SUMPRODUCT(--(A1:A65000="DFW"),--(F1:F65000))/COUNTIF(A1:A65000,"DFW")
Regards,
Alan.
"Tammy" wrote in message
...
what's wrong with this statement?

=AVERAGE(if A1:A65000="DFW",F1:F65000)

i want my spreadsheet to give me the average of the percentages listed in
column F where column A = dfw ...
thanks