I have a row of cells that have zeros in them. At any time these zeros
could change to a value. At the end of the row there's a cell that
will calculate an average of all the values. The problem I'm having is
that it's counting the zeros. What I would like is for it to exclude
the zeros and only take an average of the values.
I have a row of cells that have zeros in them. At any time these zeros could change to a value. At the end of the row there's a cell that will calculate an average of all the values. The problem I'm having is that it's counting the zeros. What I would like is for it to exclude the zeros and only take an average of the values.
"Martix" <ig.martix@gmail.com> a écrit dans le message de news: 1182992215.026378.228100@k29g2000hsd.googlegroups.com...
I know there's a way to do this.
I have a row of cells that have zeros in them. At any time these zeros
could change to a value. At the end of the row there's a cell that
will calculate an average of all the values. The problem I'm having is
that it's counting the zeros. What I would like is for it to exclude
the zeros and only take an average of the values.
I have a row of cells that have zeros in them. At any time these zeros could change to a value. At the end of the row there's a cell that will calculate an average of all the values. The problem I'm having is that it's counting the zeros. What I would like is for it to exclude the zeros and only take an average of the values.
JB
=Sum(A1:A10)/CountIf(A1:A10;"<>0")
JB
On 28 juin, 02:56, Martix wrote:
I know there's a way to do this.
I have a row of cells that have zeros in them. At any time these zeros could change to a value. At the end of the row there's a cell that will calculate an average of all the values. The problem I'm having is that it's counting the zeros. What I would like is for it to exclude the zeros and only take an average of the values.
=Sum(A1:A10)/CountIf(A1:A10;"<>0")
JB
On 28 juin, 02:56, Martix <ig.mar...@gmail.com> wrote:
I know there's a way to do this.
I have a row of cells that have zeros in them. At any time these zeros
could change to a value. At the end of the row there's a cell that
will calculate an average of all the values. The problem I'm having is
that it's counting the zeros. What I would like is for it to exclude
the zeros and only take an average of the values.
I have a row of cells that have zeros in them. At any time these zeros could change to a value. At the end of the row there's a cell that will calculate an average of all the values. The problem I'm having is that it's counting the zeros. What I would like is for it to exclude the zeros and only take an average of the values.