Unlock a world of possibilities! Login now and discover the exclusive benefits awaiting you.
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
Have you tried just using avg(FIELD) to get the average per field?
Hi,
Try this->
=sum(RECORDS)/count(if(not isnull(RECORDS),RECORDS))
Hope it helps
Regards
Apurva
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))