| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
Averaging non contiguous numbers
I want to average numbers from different columns that are not contiguous. I
also do not want to include any zeros in the average. Is it possible to use the Average/If function to do this. When I try to enter the different columns separated by commas, I get a message that there are too many arguments. I am using Excel 2003 -- ssg |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
Averaging non contiguous numbers
Is there a pattern to the cells you want to average?
-- Biff Microsoft Excel MVP "ssg" wrote in message ... I want to average numbers from different columns that are not contiguous. I also do not want to include any zeros in the average. Is it possible to use the Average/If function to do this. When I try to enter the different columns separated by commas, I get a message that there are too many arguments. I am using Excel 2003 -- ssg |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Averaging Only the X Highest Numbers in a Row | Excel Worksheet Functions | |||
| add all contiguous numbers-column-row | New Users to Excel | |||
| Weighted avg of numbers not in contiguous row-ie array w lookup? | Excel Worksheet Functions | |||
| Average Non-Contiguous numbers | Excel Worksheet Functions | |||
| Averaging Numbers when 2 numbers in one cell | Excel Worksheet Functions | |||
Linear Mode
