ExcelBanter

ExcelBanter (https://www.excelbanter.com/)
-   Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)
-   -   How do you get a average of some percentage figures (https://www.excelbanter.com/excel-discussion-misc-queries/117618-how-do-you-get-average-some-percentage-figures.html)

Raich

How do you get a average of some percentage figures
 
I have a list of percentage figures and need to add them up and get a average
how do I do this.

Dave F

How do you get a average of some percentage figures
 
=AVERAGE(range) where range is the range of cells you want to average.

Dave
--
Brevity is the soul of wit.


"Raich" wrote:

I have a list of percentage figures and need to add them up and get a average
how do I do this.


Earl Kiosterud

How do you get a average of some percentage figures
 
For the sum: =SUM(A2:A10)
For the average: =AVERAGE(A2:A10)
--
Earl Kiosterud
www.smokeylake.com
-----------------------------------------------------------------------
"Raich" wrote in message
...
I have a list of percentage figures and need to add them up and get a
average
how do I do this.





All times are GMT +1. The time now is 09:55 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com