Hi,
I have 6 cells into which any number (including zero) can be entered. What I want is the average of these 6 cells where the entered value is >0.
ie, if the values entered are - 38,40,0,0,0,0 - into each cells, then the average must be 39, which is the average of non-zero cells. How can this...