Avg where question

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

avg ? 16
Avg where ? 1
AVg question 6
formula, code or macro? 5
Obtaining an average by typing the salesman you want to see and the column to AVG 2
another excel question, thanks guys! 4
averaging a column of letter grades into a numeric GPA 3
MTD Formula Help! 1

Back
Top