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?

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?