Sum numbers only

[Christine Wilso]

I have a column of data which contains numbers and also #N/A where dat
does not exist as yet.
How do I calculate the sum of all the numbers so that #N/A is ignore
and does not interfere with my calculation

 

[Frank Kabel]

Hi
try:
=SUMIF(A:A100,"<>#NA")

thozgh it would be probably better to prevent the #NA errors. Which
formula does create this error?

--
Regards
Frank Kabel
Frankfurt, Germany

"Christine Wilso" <[email protected]>
schrieb im Newsbeitrag
news:[email protected]...