Average
 

How can I get a average of a row without the cells that contain 0?

Average
 

=SUMIF(A2:E2,"<0")/COUNTIF(A2:E2,"<0")

you can also use an array formula like


=AVERAGE(IF(2:2<0,2:2))

entered with ctrl + shift & enter


--


Regards,


Peo Sjoblom



"Matt" wrote in message
...
How can I get a average of a row without the cells that contain 0?

Average
 

=sum(1:1)/(count(1:1)-countif(1:1,0))

(if you're looking at row 1)

Matt wrote:

How can I get a average of a row without the cells that contain 0?

--

Dave Peterson

Average
 

What I have is the average of C38:p38 I dont want to average any 0 that may
showup in these cells..

"Peo Sjoblom" wrote:

=SUMIF(A2:E2,"<0")/COUNTIF(A2:E2,"<0")

you can also use an array formula like


=AVERAGE(IF(2:2<0,2:2))

entered with ctrl + shift & enter


--


Regards,


Peo Sjoblom



"Matt" wrote in message
...
How can I get a average of a row without the cells that contain 0?

Average
 

Thanks I just got it to work

"Dave Peterson" wrote:

=sum(1:1)/(count(1:1)-countif(1:1,0))

(if you're looking at row 1)

Matt wrote:

How can I get a average of a row without the cells that contain 0?

--

Dave Peterson

Average
 

change A2:E2 to C38:P38 in both spots and test it out.

Matt wrote:

What I have is the average of C38:p38 I dont want to average any 0 that may
showup in these cells..

"Peo Sjoblom" wrote:

=SUMIF(A2:E2,"<0")/COUNTIF(A2:E2,"<0")

you can also use an array formula like


=AVERAGE(IF(2:2<0,2:2))

entered with ctrl + shift & enter


--


Regards,


Peo Sjoblom



"Matt" wrote in message
...
How can I get a average of a row without the cells that contain 0?




--

Dave Peterson