the normal average function will ignore non numeric values

if there are no numbers in the range

if(iserror(average(e8:n8)),"",average(e8:n8))

otherwise the previous post but it will give 0 if the range is blank,
it depends what youwant

Regards

Dav


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