Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
![]()
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! |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
IF/VLOOKUP with #N/A results | Excel Discussion (Misc queries) | |||
Sum results of VLOOKUP | Excel Worksheet Functions | |||
vlookup results in 0 | Excel Discussion (Misc queries) | |||
to sum up all value results from VLOOKUP | Excel Worksheet Functions | |||
how do you add vlookup results? | Excel Worksheet Functions |