how to get following result?

[buzzy996]

hi,

101    3     4      5

102    2            2

103          5      1

104    4    2      3

----------------------

      3.0    3.7   2.75 (result)--->sumof the records/number of records excluding empty cells

thx

[swuehl]

Have you tried just using avg(FIELD) to get the average per field?

[#3]

Hi,

Try this->

=sum(RECORDS)/count(if(not isnull(RECORDS),RECORDS))

Hope it helps

Regards

Apurva

[#4]

Hello.

The solution with Avg (that propuse swuehl) is the correct answer.

Another solution, and this lets you know some function is as follows:

= Sum (Field) / (Count (Field) - MissingCount (Field))