Register now or log in to join your professional community.
=Average(Range) -------------------------------
I think the answer is :
A- =SUM(A2:A5)/4 = (4+2+0+4)/4=2.5
B- =AVERAGE(B2:B5) = (4+2+0+4)/4=2.5
C- =AVERAGEIF($C$2:$C$5,"<>0") = (4+2+4)/3=3.3333333
=Average(number1, number2, number3)
AVERAGE(A2:A6) IS THE BEST METHOD
=AVG()Average Formula in Excel
=Average(Range)................................................................ in the cell you want the answer to appear
in formula bar or in your cell
=average(select range)
Average calculation by using Excel
=AVERAGE(RANGE) ENTER
we can write it in many ways
The average formula for cells in column A :
=Average(A2:A5)
or
= Average(A2,A3,A4,A5)
Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.