Here's one I've never dealt with before: I have calculated columns (in a SharePoint 2013 survey) that calculate values based on particular survey questions. One of those values, however, is an "N/A" value (currently set to the number zero). What I'm trying to do is this - I need to create an average of the NON-N/A answers. For example - I have 4 survey questions from which I extrapolate an average. If one of the of the answers is N/A, I need to get the average of the other three only. What should my calculated column formula be? I've never fathomed this one before.
I know that in Excel, we could use a function like this:
=AVERAGEIF(A2:D2, ">0")
But SharePoint doesn't recognize AVERAGEIF. Does this example help?