I been trying and trying different formulas to get rid of this DiV0! Error and nothing is working.
Any idea how
Untitled 1.ods (55.2 KB)
to fix this simple formula ?
On G65
What about
=IFERROR(AVERAGEIF(D39~D46~D53~D60~D67;"<>0");"No data")
Thats seems to work !
I had to modify it to this though
=IFERROR(AVERAGEIF(D45~D52~D59~D66,"<>0"),"")
The one you posted works but it shows “No data” in the empty cell.