Sum problem

  • Thread starter Thread starter RyneFan
  • Start date Start date
R

RyneFan

I'm using a VLOOKUP formula to find an amount of money won from the weekend's
golf tournament. VLOOKUP(Weekly!$A$3:$A$199,'2004 Results'!$D$3:$Z$151,5,FALSE)
I get the results I'm looking for but here's my problem. If the golfer didn't
make the money list for the weekend the formula returns a "#N/A". When I try to
add up an owners total winnings for the week I get the same "#N/A" message,
even when there are money amounts in some of the other cells. How can I sum a
column of numbers that would ignore the "#N/A" result?

Thanks

GinGin
 
Hi
I'd change the VLOOKUP formula as follows:
=IF(ISNA(your_vlookup_formula),0,your_vlookup_formula)

HTH
Frank
 
Couldn't you use SumIf instead of Vlookup?

Also, you can sum an #N/A-ridden range with SumIf:

=SUMIF(Range,"<>#N/A")
 
Back
Top