Thread
:
Avg where question
View Single Post
#
1
Posted to microsoft.public.excel.misc
Don Guillett
external usenet poster
Posts: 10,124
Avg where question
It appeared. See original thread for the answer
--
Don Guillett
SalesAid Software
"Tammy" wrote in message
...
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)
Reply With Quote
Don Guillett
View Public Profile
Find all posts by Don Guillett