Forum Discussion
Solved
exel average formula
HI. I need Your help. Have a great massive of data like this: A B C Expected result 1 a 4 -average (B1:B4) 2 a 4.1 -average (B1:B4) 3 a 3.5 -ave...
That could be
=AVERAGEIF($A$1:$A$30,A1,$B$1:$B$30)
That could be
=AVERAGEIF($A$1:$A$30,A1,$B$1:$B$30)