Sum of a invoice- problem with vlookup
 

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.

Sum of a invoice- problem with vlookup
 

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.

Sum of a invoice- problem with vlookup
 

Try something like this:

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


--

HTH,

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

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