Average

[Matt]

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

 

[Peo Sjoblom]

=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

 

[Dave Peterson]

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

(if you're looking at row 1)

 

[Matt]

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

 

[Matt]

Thanks I just got it to work

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

(if you're looking at row 1)

 

[Dave Peterson]

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