Beautiful. I knew there was a criteria operand missing. The ones they never
tell you about.
One thing I've found it's almost impossible to find the #N/A when it's
associated with a formula. It's equally impossible to sum up autofiltered
data with # N/A in it.
Thank you,
Paul
"Max" wrote:
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