Think you could use something like this in say, C1:
=SUMIF(B:B,"<#N/A")
where col B contains the vlookup returns which may include #N/A returns
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---
"PayPaul" wrote:
I am trying to sum up a column a data which includes numbers and the #N/A
indicator. These numbers are from a vlookup formula. The column is in a
spreadsheet that's been autofiltered for specific text in another column. How
do I add up the numberd derived from the vlookup formula in the column with
the condition that #N/A does not get included in that equation. The #N/A
totally messes up the sum equation.

Thank you,

Paul