I use the function AVERAGEIF: =AVERAGEIF(A5:A9,">0"). There is surely no zero or empty value in the cells A5:A9, all values are whole numbers. However, it returns #DIV/0! error. Please, how can I fix it?
Averageifii.ods (10.6 KB)
Click View > Value highlighting and you will see that your “numbers” are text (black) not numbers (blue).
See Calc Number text to Numeric data
2 Likes
Thank you, it works.