Try
=SUMIF(C2:D2,"<#N/A")

You can handle the #na in your VLOOKUP() formula like

=IF(ISNA(vlookupformula),0,vlookupformula)
or
=IF(ISNA(vlookupformula),"",vlookupformula)

If this post helps click Yes
---------------
Jacob Skaria


"duketter" wrote:

Excel 2007 - I have vlookup formulas in cell c2 and d2. In c2 the result of
the vlookup is 5 and in d2 the results of the vlookup is #n/a. I then need
to sum cell c2 and d2 but I cannot since d2 contains #n/a. How can I
remove/change this so I can sum these two cells together?

Thanks!