use this formula in your vlookup, it will replace your N/A errors with blanks
=IF(ISNA(vlookup),"",vlookup)
replace vlookup with your formula.
--
-John
Please rate when your question is answered to help us and others know what
is helpful.


"Chrisinct" wrote:

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.