Sum ignoring cells with error

[JRD]

How does one sum up values in a column ignoring cells that contain #N/A error?

 

[Peo Sjoblom]

=SUMIF(A:A,"<>#N/A")

for all errors

=SUMIF(A:A,"<"&99^99)





--


Regards,


Peo Sjoblom