|
|
Works great! Thanks!
PG
Domenic wrote:
Try...
=IF(COUNT(Z54:AD54)-COUNTIF(Z54:AD54,0),SUM(Z54:AD54)/(COUNT(Z54:AD54)-CO
UNTIF(Z54:AD54,0)),0)
or
=IF(COUNT(Z54:AD54)-COUNTIF(Z54:AD54,0),AVERAGE(IF(Z54:AD54,Z54:AD54)) ,0)
...confirmed with CONTROL+SHIFT+ENTER, not just ENTER.
Hope this helps!
I am trying to do an average of values in a range of cells across colunms,
where only values other than zero are counted in the divisor. For example, I
[quoted text clipped - 14 lines]
this problem: "<0<", "0", "<"&"0", "<"&B4 (where the value in cell B4 is
zero) and nothing works. Can someone help me out on this?
--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200509/1
|