I'm trying to calculate standart deviation, but I need a way to ignore the cells with value 0.
For example, in the following image, standart deviation of
J4:M4 should be
M4). Since the location of the zeros are not fixed (not in the same column) I can't just use
J4:L4. For the 6th row, I need to ignore
I need a flexible solution, like
=AVERAGEIF(J4:M4,">0"). How should I proceed?