View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Gino59 Gino59 is offline
external usenet poster
 
Posts: 5
Default Sum the results of a vlookup

Hi y'all...

Been looking all over but no luck! I have a column of results from a
vlookup that works just fine. It basically takes a discount code number and
returns a dollar value (ie; code 1 returns $100, code 2 returns $50, etc.).

All I want to do at the bottom of that column is sum up the total $ value.
And all I get is #N/A...

There are no #N/A's returned in the vlookup cells, it's just when I try to
total the cells with what I though would be a simple =sum(e3:e30) that I get
the error.
(e3:e30 have the vlookup results).

I just know this is going to be one of the "D'oh" moments for me!
Suggestions??

Thanks all y'all!