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

[Guest]

 

[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")

 

[Guest]

Thanks for trying Frank, but it came up with "Value" error message.

Any other thoughts? Thanks

 

[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.

 

[Guest]

Dave, It worked perfectly. Thank you very much.
Richard