LinkBack Thread Tools Search this Thread Display Modes
Prev Previous Post   Next Post Next
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
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!
 
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
IF/VLOOKUP with #N/A results Supe Excel Discussion (Misc queries) 6 July 2nd 09 09:30 PM
Sum results of VLOOKUP Dewayne Excel Worksheet Functions 7 November 28th 07 04:53 PM
vlookup results in 0 sveazie Excel Discussion (Misc queries) 6 July 17th 07 09:20 AM
to sum up all value results from VLOOKUP Linn Excel Worksheet Functions 1 March 7th 07 02:45 AM
how do you add vlookup results? Anna Excel Worksheet Functions 3 March 26th 05 03:05 AM


All times are GMT +1. The time now is 02:26 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"