Use AVERAGE()


The AVERAGE() function will ignore empty or missing values. For example if
you enter =AVERAGE(A1:A9) in cell A10 and only jave data in A1, A3, and A5,
the other values in the range will be ignored/
--
Gary''s Student


"MR1" wrote:

Hi,

I am tyring to caluculate averages but only in cells above where there is
data, i.e. I want it to stop when there is no more data above. Is there an
easy way to do this. I have a number of fields with different numbers of data
and don't want to have to go through and fix every field?

Help please?