Just a quick question

[Brian Shafer]

I want to be able to average a range of cells, some of these cells are 0,
and those are the ones I don't to include in on the calculation.

 

[Jim Cone]

Brian,

If your data is in "B514"...

=SUM(B514)/COUNTIF(B514,">0")

Regards,
Jim Cone
San Francisco, CA

 

[A.W.J. Ales]

Brian,

If your range actually contains 0 values the following formula (based on a
range G1:G5 will help.
=COUNTIF(G1:G5;"<>0")/COUNTIF(G1:G5;"<>0")

If however your range contains empty cells, the function AVERAGE itself
deals with that. It is calculating the average of non empty cells.

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[A.W.J. Ales]

Sorry,
Formula should be :
=SUM(G1:G5)/COUNTIF(G1:G5;"<>0")

--
Regards,
Auk Ales

* Please reply to this newsgroup only *
* I will not react on unsolicited e-mails *

 

[Don Guillett]

This is an array formula and must be entered/edited with control+Shift+enter
instead of just enter.

=AVERAGE(IF(D110>0,D110))