Excel 2003

[Guest]

Hi,

How do I use the sum function on a column where I have used Vlookup and
#N/A appears - the sum function will not total the dollar amounts.

Is there a work around or formula change available ?

Thanks for your help

 

[Guest]

On your vlookup you can add an if isna(vlookup),0,(vlookup)
that way it puts a zero in the cell rather than N/A

 

[Guest]

=SUM(IF(ISNUMBER(A1:A100),A1:A100))

ctrl+shift+enter, not just enter

 

[T. Valko]

Try this:

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