Forum Discussion
nattiej101
Aug 12, 2022Brass Contributor
Average of non-zeros
Hello! I am trying to get an average of non-zero values. So for the row one, I need it to be 0, but for row 2, I need it to be we have one value, and we divide by one value. So I need:
Sum(all the values) / (number of cells that have a value greater than 0).
Thanks in advance!
2 Replies
- Detlef_LewinSilver Contributor
- OliverScheurichGold Contributor
=AVERAGEIF(A2:D2,">0",A2:D2)You can try AVERAGEIF which returns the expected result in my sheet.