Sample data:
1 2 #REF! 3 #REF! 5
=SUM(IFERROR(A1:D6,""))
returns 11.
=SUM(IF(ISERROR(A1:A6),1))
returns 2.