Summing a column that includes NA( )s

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

I have a column of numbers and NA( )s that are a result of a VLOOKUP function that I have entered. I want to be able to calculate the sum of the column of numbers, OR, embed a conditional statement into the VLOOKUP that will return zero if the result of the lookup is NA( ). I have not been able to figure out how to do this. Please help. Thank you.
 
Danny,

=IF(ISNA(VLOOKUP...),"",VLOOKUP...)

--

HTH

Bob Phillips
... looking out across Poole Harbour to the Purbecks
(remove nothere from the email address if mailing direct)

Danny Coyle said:
I have a column of numbers and NA( )s that are a result of a VLOOKUP
Click to expand...
function that I have entered. I want to be able to calculate the sum of the
column of numbers, OR, embed a conditional statement into the VLOOKUP that
will return zero if the result of the lookup is NA( ). I have not been able
to figure out how to do this. Please help. Thank you.
 
If NAs are unpleasant to the eye, follow Bob's advice. If
not, just use:

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

HTH
Jason
Atlanta, GA
-----Original Message-----
I have a column of numbers and NA( )s that are a result
Click to expand...
of a VLOOKUP function that I have entered. I want to be
able to calculate the sum of the column of numbers, OR,
embed a conditional statement into the VLOOKUP that will
return zero if the result of the lookup is NA( ). I have
not been able to figure out how to do this. Please help.
Thank you.
 
Back
Top