Hi,
I'm trying to sum a row of values, and then calculate the average value. In the row all zero values will be denoted #N/A. The zero values are denoted #N/A to remove the zero-entries when the values are plotted in a graph.
This is my formula for calculating the average, but i'm getting an error and i'm guessing that it has to do with ">0". How can this argument skip #N/A entries?
=SUM(O4:AS4)/(COUNTIF(O4:AS4;">0"))
BR
Bjanger
I'm trying to sum a row of values, and then calculate the average value. In the row all zero values will be denoted #N/A. The zero values are denoted #N/A to remove the zero-entries when the values are plotted in a graph.
This is my formula for calculating the average, but i'm getting an error and i'm guessing that it has to do with ">0". How can this argument skip #N/A entries?
=SUM(O4:AS4)/(COUNTIF(O4:AS4;">0"))
BR
Bjanger