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

Hello can anybody tell me what what with my statement?

I want my spread sheet to figure an average of the values in column F Where
the value in column A = DFW.


=AVERAGE(A2:A65000,MATCH("dfw",F2:F65000,0),0)