How to take average of a column in Microsoft Excel? / myLot

India

June 20, 2007 3:13am CST

Is there an automatic way?

1 person likes this

3 responses

• India

20 Jun 07

I has on =AVERAGE functions Usage: =AVERAGE(StartingCell..EndingCell)

2 people like this

• China

27 Aug 07

I think you are right. =AVERAGE( , )

• India

20 Jun 07

You can even you the formula bar; it has average function by default and many other are available from the drop down.

1 person likes this

• United States

3 Jul 07

Another way to average would be to use subtotal =subtotal(1,a1:a65000)