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

--

Dave Peterson

XXXX@XXXXX.COM

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

Or the somewhat shorter

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

--

Regards,

Peo Sjoblom

do it

type

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

--

Regards,

Peo Sjoblom

do it

type

1. Counting A's in a table column 1, F's in column 2, etc...

2. How to add previous sums in a column to current sums in a column?

3. Select Sum(table1.column), Sum(table2.column)

4. Can I SUM column C IF Column A=X AND Column D=Y?

6. Auto sum returns a 0 value in place of sum of values in column

7. Auto sum returns a 0 value in place of sum of values in column.

8. SUM IF: How do I sum the data in a column based on 2 other col

9. sum of digits in column not giving correct sum

10. formula to sum all sum calculations in a column

11. Sum of rows does not tie to sum of columns

12. summing columns in repeating table - only sums first row

13. Sum Function - sum option not available for column of numbers

14. =sum(A:A) add to column (B) and new value repeats w/ new sums

3 post • Page:**1** of **1**