Hi,

Try this

=sumif(B2:C2,"=-9.999E307",B2:C2)

--
Regards,

Ashish Mathur
Microsoft Excel MVP

"lee-sc" wrote in message
...
Example :

E/no salary Bonus total
001 1000 #N/A
002 200 100
003 2000 #N/A

How to set a formula for each worker in total column (Salary & Bonus)when
the value are set as #N/A. How to convert #N/A to 0 for sum formula.

Please advise.

Thanks.