Start networking and exchanging professional insights

Register now or log in to join your professional community.

Follow

How do you write Average formula in Excel?

user-image
Question added by Mehboob Ali Laghari , Social Mobilization Team Incharge , TRDP-European Union
Date Posted: 2015/08/15
Shahbaz Hayder
by Shahbaz Hayder , Group Head of Finance , Sharif Group of Companies

=Average(Range)      -------------------------------

Hossam Mohamed
by Hossam Mohamed , Senior Accountant , Allied Arab Assurance Brokerage

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

Jamshaid Mahmood
by Jamshaid Mahmood , Project Coordinator Engineer , Ericsson

=Average(number1, number2, number3)

Tahir Nawaz
by Tahir Nawaz , Operations Manager , Askari Bank

AVERAGE(A2:A6) IS THE BEST METHOD

=average(a1:a13)

sum(a2:a5)/count(a2:a5)

 

 

 

 

 

Mohmmad Abu Qubo
by Mohmmad Abu Qubo , Deputy Director Of Finance , Starwood for hotels and resorts

=AVG()Average Formula in Excel

=Average(Range)................................................................ in the cell you want the answer to appear  

Parwez Alam Parwez
by Parwez Alam Parwez , Logistics Coordinator , Qatar Engineering and Construction Company

in formula bar or in your cell

=average(select range)

Average calculation by using Excel

=AVERAGE(RANGE) ENTER

 

Imdad Hussain Rajput
by Imdad Hussain Rajput , Assistant Sales Manager , Forego

we can write it in many ways

Said Shaban
by Said Shaban , Accountant , Tri State Materials Testing

The average formula for cells in column A :

=Average(A2:A5) 

or

 = Average(A2,A3,A4,A5)

More Questions Like This

Do you need help in adding the right keywords to your CV? Let our CV writing experts help you.