| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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. |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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. |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average price of 4 columns of figures but some cells can be blank | Excel Worksheet Functions | |||
| moving average of figures from separate tables | Excel Discussion (Misc queries) | |||
| Average a set of figures which ignores 0 entries | Excel Worksheet Functions | |||
| Average Percentage help please | New Users to Excel | |||
| calculate average in percentage coloumn with #DIV/! (ignore error | Excel Discussion (Misc queries) | |||
Linear Mode
