How to find average of selected cells and not include zero

T

Tilsted

Joined
Jul 7, 2011
Messages
2
Reaction score
0
Hi all,

I have a problem with an average i want to count.

Say i want to count the average from differnet selected cells say

cell A1,B4,C9,D10,E12

and some of the cells have the value 0 in them, so i don't want the formula to include these as long as they have the value 0.

I have tried to google this but i can't seem to fint the solution. I have tried to divide with a sumproduct and i can get i to work if it is cells next to each other like A1:A20, but not if i want to do it with different selected cells.

Hope you can help:-)
 
And I properly should mention that there are values in the cells sourrounding the cells I want to take the average of.
 
Back
Top