Hi
I wish to average a number of cells, but only if all the cells in the range are >0. I have tried using =AVERAGEIF(A1:A5 ,">0"), but this includes any odd cells that are >0 and in the first example below, gives an answer of 3 when it should be 0. The second example shows the result should only be when all values are > 0.
Maybe this should be easy, but I cannot find a solution, any help appreciated.
I wish to average a number of cells, but only if all the cells in the range are >0. I have tried using =AVERAGEIF(A1:A5 ,">0"), but this includes any odd cells that are >0 and in the first example below, gives an answer of 3 when it should be 0. The second example shows the result should only be when all values are > 0.
A  A  
1  0  1  2 
2  0  2  2 
3  0  3  2 
4  0  4  2 
5  3  5  2 
Answer Required  0  2 
