Sum of a invoice- problem with vlookup

[Chrisinct]

I created an invoice that takes a product and posts the price of that product
into the invoice which is then multiplied by the quantity. This part works
absolutely fine however on the lines of the invoice where there is no data
entered the formula returns #N/A. The problem is when I go to sum the
collumn it always returns #N/A.

How can I use that formula and get it to sum for an invoice total without
resulting in #N/A?.

Thanks in advance for your help.

 

[John Bundy]

use this formula in your vlookup, it will replace your N/A errors with blanks
=IF(ISNA(vlookup),"",vlookup)
replace vlookup with your formula.

 

[RagDyeR]

Try something like this:

=If(Isna(your formula),"",your formula)


--

HTH,

RD
=====================================================
Please keep all correspondence within the Group, so all may benefit!
=====================================================

I created an invoice that takes a product and posts the price of that
product
into the invoice which is then multiplied by the quantity. This part works
absolutely fine however on the lines of the invoice where there is no data
entered the formula returns #N/A. The problem is when I go to sum the
collumn it always returns #N/A.

How can I use that formula and get it to sum for an invoice total without
resulting in #N/A?.

Thanks in advance for your help.