Calculating the average of cells
 

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?

Calculating the average of cells
 

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

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?

=average(<range1,<range2...)

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

Calculating the average of cells
 

Many thanks Steve

"SteveW" wrote:

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

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?

=average(<range1,<range2...)

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