average formula

[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.

 

[Dave R.]

Try

=average(if(d1:d100=a1,f1:f100))

*entered with CTRL SHIFT ENTER*

 

[Aladin Akyurek]

=AVERAGE(IF($D$1:$D$100=A1,$F$1:$F$100))

which must be confirmed with control+shift+enter instead of just with enter.

 

[Barbara]

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$11=$A$1,$F$1:$F$11))
array formula (to be entered with CTRL+MAIUSC+INVIO)

Hope it could help you.

Regards
Barbara

 

[Barbara]

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

oops... CTRL+SHIFT+ENTER...

Barbara

 

[Jose]

-----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.
.

Thanks to all who posted. The formula works.

Thanks