| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
How do I get the average of entries in a group of columns?
I have a set of 4 columns of data that are all the result of a different
division formula corresponding to each column. Many of the entries are a #DIV/0! entry. I would like to take a single average of all the actual numeric entries in the entire set of columns that were greater than zero (0) and less than ten (10) in value. How would you suggest I proceed? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| average low 10 of last 20 entries | Excel Worksheet Functions | |||
| How do I group multiple data entries in sub-groups | Excel Worksheet Functions | |||
| Average of column entries | Excel Discussion (Misc queries) | |||
| Any way to calculate an average for more than 30 entries? | Excel Worksheet Functions | |||
| Hyperlink for a group of addresses without individual entries? | Excel Discussion (Misc queries) | |||
Threaded Mode
