Averaging non contiguous numbers

's Computer Specifications

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

's Computer Specifications

Is there a pattern to the cells you want to average?

--
Biff
Microsoft Excel MVP

"ssg" <(E-Mail Removed)> wrote in message
news:6338EF9C-249A-47FC-8848-(E-Mail Removed)...
>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

Thread Tools
Show Printable Version Email this Page
Rate This Thread
Rate This Thread:

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
Averaging many non-contiguous cells if they are blank	Nadine	Microsoft Excel Worksheet Functions	1	12th Apr 2010 11:25 PM
averaging non-contiguous data using arrays	Matt S	Microsoft Excel Programming	1	2nd Jun 2009 09:13 PM
add all contiguous numbers-column-row	JClark	Microsoft Excel New Users	2	2nd May 2006 11:52 PM
Average Non-Contiguous numbers	=?Utf-8?B?VGVyaQ==?=	Microsoft Excel Worksheet Functions	1	20th Jan 2005 08:33 PM
Re: Averaging Numbers when 2 numbers in one cell	=?Utf-8?B?T3VyYW5pYQ==?=	Microsoft Excel Worksheet Functions	1	12th Jan 2005 06:40 PM