Hello
One way is the Sumif function, for example:

=SUMIF(A2:A3,"<>#VALUE!",A2:A3)
Hope this helps.
DBY