=(((E5*1.05)/(E4*1.05))+((E6*0.89)/(E4*0.89))+((E7/E4)/(E4*60)))/COUNTIF(E5:E7,"0")

OR

=SUM((E5*1.05)/(E4*1.05)+(E6*0.89)/(E4*0.89)+(E7/E4)/(E4*60))/COUNTIF(E5:E7,"0")

"fivermsg" wrote:


so what you are saying is that if one of those inner formulas =0 then it
would omit that one and just average the other two?


--
fivermsg
------------------------------------------------------------------------
fivermsg's Profile: http://www.excelforum.com/member.php...o&userid=32348
View this thread: http://www.excelforum.com/showthread...hreadid=521869