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 |
|