G
Gino59
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!
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!