You can test each cell by entering this formula

In F3: =ISERROR(E3)
copy down to F30. If the formula returns TRUE which mean,that cell has an
error like #n/a. Either you can fix the error cell(s), or you can use this
formula

=SUMIF(E3:E30,"<1E100")




"Gino59" wrote:

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!