Sum numbers only

C

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
 
F

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]...
 
Top