Hi Biff,

Thank you very much - your Formula works well too.

Thanks
Sam

Biff wrote:
=SUMIF(A1:E1,"<#N/A")/COUNTIF(A1:E1,"0")


--
Message posted via OfficeKB.com
http://www.officekb.com/Uwe/Forums.a...tions/200507/1