Calculating average over multiple columns

[thower]

Hi!
I am trying to find a simple way to calculate average value over multiple columns.
When doing so I want to exclude columns containg blanks or nulls (whatever is easiest to identify)

Example:

Col1 Col2 Col3 Av
1 2 3 6/3=2
null 4 8 12/2=6

Anyone have an idea?
Thanks in advance

 

[Rudi]

Hi,

When you add a column (Add Column > Statistics > Average), the average is calculated correctly as it does not evaluate nulls.
Simply select the numeric columns and insert an average.

See image...

View attachment 7322

 

[thower]

Wow! That simple! Many thanks!
/Thomas