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

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
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Excel0247" wrote:

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

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

ctrl+shift+enter, not just enter


"Excel0247" wrote:

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

Try this:

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

--
Biff
Microsoft Excel MVP


"Excel0247" wrote in message
...
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