Really struggling with formula on a calculated column on my SharePoint list for some reason!
I am trying to get the average of 3 columns sometimes one will be blank some times there will be no blanks.
Here is the formula I have:
=IF(COUNT([Column1],[Column2],[Column3])="","",SUM([Column1],[Column2],[Column3])/COUNT([Column1],[Column2],[Column3]))
On this test Column 2 is empty and this returns #DIV/0!
Any help would be gratefully received.