average formula

  • Thread starter Thread starter Jose
  • Start date Start date
J

Jose

I need to do an average using a vlookup I think. I am
looking up the criteria (A1) in fields D1 - D100. I need it
to pull and average the data that is in F1 - F100 that
meets the criteria. The data in A1 is found multiple times
in column D.
 
=AVERAGE(IF($D$1:$D$100=A1,$F$1:$F$100))

which must be confirmed with control+shift+enter instead of just with enter.
 
Jose said:
I need to do an average using a vlookup I think. I am
looking up the criteria (A1) in fields D1 - D100. I need it
to pull and average the data that is in F1 - F100 that
meets the criteria. The data in A1 is found multiple times
in column D.
Click to expand...


=AVERAGE(IF($D$1:$D$11=$A$1,$F$1:$F$11))
array formula (to be entered with CTRL+MAIUSC+INVIO)

Hope it could help you.

Regards
Barbara
 
-----Original Message-----
I need to do an average using a vlookup I think. I am
looking up the criteria (A1) in fields D1 - D100. I need it
to pull and average the data that is in F1 - F100 that
meets the criteria. The data in A1 is found multiple times
in column D.
.
Click to expand...
Thanks to all who posted. The formula works.

Thanks
 
Back
Top