Use this:
=IF(A10:A15=A6,AVERAGE(B10:B15),"")
Ctrl+Shift+Enter


To see how Excel handles calculations, functions, etc. click on Tools
Formula Auditing Evaluate Formula


Regards,
Ryan---

--
RyGuy


"Gaurav" wrote:

Hi All,

I have this formula {=AVERAGE(IF($A$10:$A$5066=A6,B$10:B$5066))}. As far as
my knowledge goes, i do not see anything wrong with the formula but why is
calculating a different average than the normal
=AVERAGE(number1,number2,number3....) formula?

as per the current figures I have the result as 230.21 but when i calculate
the same manually with the normal average formula, it gives me 278.17. I
figured its not working properly when i entered 1 in one of the cells and
the average went up instead of going down.

Help required.

Thanks
Gaurav