software

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

=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:
gt;
gt; I have columns of data that I need to sum. Some of these cells have #NUM! in
gt; them. How would I sum these columns?
gt;
gt; Thanks in advance for your ideas...

--

Dave Peterson

Thanks alot...works great...

quot;Dave Petersonquot; wrote:

gt; =sum(if(isnumber(a1:a10),a1:a10))
gt;
gt; This is an array formula. Hit ctrl-shift-enter instead of enter. If you do it
gt; correctly, excel will wrap curly brackets {} around your formula. (don't type
gt; them yourself.)
gt;
gt; Adjust the range to match--but you can't use the whole column.
gt;
gt; steve_sr2 wrote:
gt; gt;
gt; gt; I have columns of data that I need to sum. Some of these cells have #NUM! in
gt; gt; them. How would I sum these columns?
gt; gt;
gt; gt; Thanks in advance for your ideas...
gt;
gt; --
gt;
gt; Dave Peterson
gt;