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