ExcelBanter - Averaging non contiguous numbers

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - Averaging non contiguous numbers (https://www.excelbanter.com/excel-discussion-misc-queries/169047-averaging-non-contiguous-numbers.html)

ssg

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

T. Valko

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

All times are GMT +1. The time now is 10:47 PM.