I posted this question a minute ago, but it never appeared, so I'm reposting.
thanks

On my spreadsheet, Column A contains airports, Column F contains percentages.

I want my spreadsheet to look for every instance of DFW in Column A and then
average the percentages found in Column F.

I came up with this but it's not working
=AVERAGE(A2:A65000,"dfw",N2=F2:F65000)