software

I am trying to use a formula to calculate the average of random cells
currently containing data, however also including cells where data will be
added at a later date but remain empty. Is this possible?

On Mon, 13 Mar 2006 12:53:27 -0800, pippa
gt; wrote:

gt;I am trying to use a formula to calculate the average of random cells
gt;currently containing data, however also including cells where data will be
gt;added at a later date but remain empty. Is this possible?

=average(lt;range1gt;,lt;range2gt;...)

will work quite happily with blanks and non numeric values
but will not accept cells with calculation errors (not a problem if
all your cells are just data)--

Steve

Many thanks Steve

quot;SteveWquot; wrote:

gt; On Mon, 13 Mar 2006 12:53:27 -0800, pippa
gt; gt; wrote:
gt;
gt; gt;I am trying to use a formula to calculate the average of random cells
gt; gt;currently containing data, however also including cells where data will be
gt; gt;added at a later date but remain empty. Is this possible?
gt;
gt; =average(lt;range1gt;,lt;range2gt;...)
gt;
gt; will work quite happily with blanks and non numeric values
gt; but will not accept cells with calculation errors (not a problem if
gt; all your cells are just data)
gt;
gt;
gt; --
gt;
gt; Steve
gt;