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

  • Thread starter Thread starter sokevin
  • Start date Start date
S

sokevin

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
 
=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.)
 
Back
Top