How can I sum numbersin a column, when I also have #N/A in same co

F

Frank Kabel

Hi
you may post your message as body of your post. But I'd guess you want
something like
=SUMIF(A1:A100,"<>#NA")
 
D

Dave Peterson

How about:

=SUM(IF(ISNUMBER(A1:A100),A1:A100))
This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
correctly, excel will wrap curly brackets {} around your formula. (don't type
them yourself.)

Change the range, but not to the whole column.
 
Top