Hi Joan

In my opinion, you would be better off getting rid of the #N/A's, rather
than trying to work around them.

Amend your Vlookup formula to either
=IF(ISNA(your_formula),"",your_formula)
or
=IF(ISERROR(your_formula),"",your_formula)

replace your_formula with your existing vlookup(.....)



--
Regards

Roger Govier


"Joan NYC" wrote in message
...
I am working on an invoice that is using VLOOKUP

I have surpressed viewing the #N/A with conditional formatting.
However, I
would like to have a sum of the columns that I have used this
conditional
formatting with.

I originally did not use conditional formatting. I was trying to
create an
"ISBLANK" formula which I could not get to work.

I know how to surpress the #N/As in printing only but I am doing this
for
someone who is quite illiterate and they want to view the invoice
"cleanly"

Any suggestions would be appreciated. Thanks. Happy New Year.