I have a SP list that will have some columns populated and some left blank. Each column is scored out of 5. If i have 3 columns with 5 and 3 columns left blank I would like the calculated column to see 3 values, add them and divide by the number of columns with values.

So in this case it would see 5,5,5 totalling 15 and divide by only 3 to give me an average of 5. Currently it would divide by 6 columns.

​I have a SP list that will have some columns populated and some left blank. Each column is scored out of 5. If i have 3 columns with 5 and 3 columns left blank I would like the calculated column to see 3 values, add them and divide by the number of columns with values. So in this case it would see 5,5,5 totalling 15 and divide by only 3 to give me an average of 5. Currently it would divide by 6 columns.  Read More

​