Calculating the average of cells

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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?
 
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?
Click to expand...

=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)
 
Many thanks Steve

SteveW said:
=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)
Click to expand...
 
Back
Top