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

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

--
Regards
Frank Kabel
Frankfurt, Germany
"Tucson Guy" schrieb im Newsbeitrag
...

"Tucson Guy" wrote:

Thanks for trying Frank, but it came up with "Value" error message.
Any other thoughts? Thanks

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.

Tucson Guy wrote:

"Tucson Guy" wrote:

Thanks for trying Frank, but it came up with "Value" error message.
Any other thoughts? Thanks

--

Dave Peterson

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

"Dave Peterson" wrote:

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.

Tucson Guy wrote:

"Tucson Guy" wrote:

Thanks for trying Frank, but it came up with "Value" error message.
Any other thoughts? Thanks

--

Dave Peterson