Hello all,
I do not know where my mind is playing tricks. Mind or math, not sure.
This is the formula that i used to average (with blue color) all the rows and all the columns in the data set (with black collor): =IFERROR(AVERAGEIF(K55:P55,"<>0",K55:P55),"")
But in the same data, if i calculate mean on column this result 4.17. On the other side, when i calculate total mean horizontally, the mean becomes 4.20. In the first place, i thought that the 0 makes the difference. Horizontally to take it as a number and vertically not. But... this is not the answer.
<colgroup><col><col><col span="6"></colgroup><tbody>
</tbody>Thank you the one who can help me to clear my mind.
I do not know where my mind is playing tricks. Mind or math, not sure.
This is the formula that i used to average (with blue color) all the rows and all the columns in the data set (with black collor): =IFERROR(AVERAGEIF(K55:P55,"<>0",K55:P55),"")
But in the same data, if i calculate mean on column this result 4.17. On the other side, when i calculate total mean horizontally, the mean becomes 4.20. In the first place, i thought that the 0 makes the difference. Horizontally to take it as a number and vertically not. But... this is not the answer.
<colgroup><col><col><col span="5"></colgroup><tbody> </tbody> | ||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||||
<colgroup><col><col><col span="6"></colgroup><tbody>
</tbody>