Need a formula to average a range of cells but only if there are numbers
so I dont get a zero.
=AVERAGE(IF(E8:N8,E8:N8)) this is what I'v tried but I just get
#VALUE!
Thanx


--
ferg
------------------------------------------------------------------------
ferg's Profile: http://www.excelforum.com/member.php...o&userid=36519
View this thread: http://www.excelforum.com/showthread...hreadid=563563