best way to sum a column with #N/a's?

best way to sum a column with #N/a's?

Post by sokevi » Thu, 12 Feb 2004 10:43:49


what is the best way to sum a column (that i polulated by using vlookup
that contains #n/a, positve and negative numbers


i am currently doing

=sumif(a1:a20,">0",a1:a20)+sumif(a1:a20,"<0",a1:a20)


anyone know of a more effiecient wa
 
 
 

best way to sum a column with #N/a's?

Post by Dave Peter » Thu, 12 Feb 2004 11:04:07

=sum(if(isnumber(a1:a20),a1:a20))
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.)



--

Dave Peterson
XXXX@XXXXX.COM

 
 
 

best way to sum a column with #N/a's?

Post by Peo Sjoblo » Thu, 12 Feb 2004 11:16:01

Or the somewhat shorter

=SUMIF(A1:A20,"<>#N/A")

--

Regards,

Peo Sjoblom



do it
type