How do I sum a range of data (column) that has #num! in some cells
 

I have columns of data that I need to sum. Some of these cells have #NUM! in
them. How would I sum these columns?

Thanks in advance for your ideas...

How do I sum a range of data (column) that has #num! in some cells
 

=sum(if(isnumber(a1:a10),a1:a10))

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

Adjust the range to match--but you can't use the whole column.

steve_sr2 wrote:

I have columns of data that I need to sum. Some of these cells have #NUM! in
them. How would I sum these columns?

Thanks in advance for your ideas...

--

Dave Peterson

How do I sum a range of data (column) that has #num! in some c
 

Thanks alot...works great...

"Dave Peterson" wrote:

=sum(if(isnumber(a1:a10),a1:a10))

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

Adjust the range to match--but you can't use the whole column.

steve_sr2 wrote:

I have columns of data that I need to sum. Some of these cells have #NUM! in
them. How would I sum these columns?

Thanks in advance for your ideas...

--

Dave Peterson