Averaging a colume of values.

's Computer Specifications

I need to average a column of numbers. The column is a result of a
calulation. Before numbers are added for the calulation, the cels I
want to average is filled with ####, My average formula comes out
###. Any help appreciated..

's Computer Specifications

Drag the column wider?

OR

Are you dealing with negative times which return #####?

Gord Dibben MS Excel MVP

On Mon, 17 Jan 2011 13:04:52 -0800 (PST), Skip <(E-Mail Removed)> wrote:

>I need to average a column of numbers. The column is a result of a
>calulation. Before numbers are added for the calulation, the cels I
>want to average is filled with ####, My average formula comes out
>###. Any help appreciated..

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

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
how to vlookup colume with different values	Bklynhyc	Microsoft Excel Worksheet Functions	2	13th Oct 2009 07:28 PM
averaging less than values	JD	Microsoft Excel New Users	1	10th Sep 2008 04:28 AM
Change from row to colume n colume to row	nirupreddys@gmail.com	Microsoft Excel Programming	2	4th Oct 2007 03:35 PM
How can I look up max of one colume and display the colume to the.	=?Utf-8?B?QnJpYW4gQ29ybmVqbw==?=	Microsoft Excel Worksheet Functions	2	21st Feb 2005 05:47 AM
Sort via a colume bring up incorrect values	James	Microsoft Excel Worksheet Functions	1	9th Jun 2004 09:42 PM