Thread: avg ?
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.misc
Tammy Tammy is offline
external usenet poster
 
Posts: 145
Default avg ?

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