Average of values in Column B based on a criteria from Column A

[Djordje8]

Hello,

I have 5000 real numbers in Column A and 5000 real numbers in Column B. I would like to average the numbers in Column B when the number in Column A are between 5.0 and 10.0. Please could you help me with this and provide some hints?

Thanks in advance!

Djordje

 

[Jonmo1]

Which version of Excel are you using?

XL2007+ you can use
=AVERAGEIFS(B:B,A:A,">=5",A:A,"<=10")

 

[Djordje8]

That worked! Thanks a lot Jonmo1!

 

[Jonmo1]

You're welcome.