Communiquez avec les autres et partagez vos connaissances professionnelles

Inscrivez-vous ou connectez-vous pour rejoindre votre communauté professionnelle.

Suivre

How do you write Average formula in Excel?

user-image
Question ajoutée par Mehboob Ali Laghari , Social Mobilization Team Incharge , TRDP-European Union
Date de publication: 2015/08/15
Shahbaz Hayder
par Shahbaz Hayder , Group Head of Finance , Sharif Group of Companies

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

Hossam Mohamed
par 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
par Jamshaid Mahmood , Project Coordinator Engineer , Ericsson

=Average(number1, number2, number3)

Tahir Nawaz
par 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
par 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
par 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
par Imdad Hussain Rajput , Assistant Sales Manager , Forego

we can write it in many ways

Said Shaban
par 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

Avez-vous besoin d'aide pour créer un CV ayant les mots-clés recherchés par les employeurs?