Thank you for being a valued part of the CNET community. As of December 1, 2020, the forums are in read-only format. In early 2021, CNET Forums will no longer be available. We are grateful for the participation and advice you have provided to one another over the years.

Thanks,

CNET Support

General discussion

Excel formula help

by nicklaus Nov 3, 2004 4:58PM PST

I tried =averagea(a1:a20) to get an average of the numbers entered in those cells but the formula didnt work. What did I do wrong. I want to average out a list of numbers.

Discussion is locked

3 Posts

- Collapse + Expand Details

- Collapse -

Did you spell correctly?

by FrankQTran Nov 3, 2004 6:02PM PST

It's should be =AVERAGE(A1:A20)

Regards,

- Collapse -

Re: Did you spell correctly?

by nicklaus Nov 4, 2004 3:21AM PST

Thanks. I know that there is an "averagea" for use somewhere. Didnt even think to use the "average". Brain cramp I guess.

- Collapse -

Glad to see you solved the problem

by FrankQTran Nov 4, 2004 3:46AM PST

Since we're in ths topic, in the future I would suggest you go to the Microsoft Office Forum for any Office relate questions at http://reviews.cnet.com/5204-6129-0.html?forumID=29&start=0

Regards,

Back to PC Applications forum