summing a Vlookup column

[dvmclau]

I have a vlookup column that I would like to sum the dollar amounts that vlookup puts in the column.
Thanks

 

[etaf]

i need a little more detail to understand what you are trying to do exactly

 

[dvmclau]

i need a little more detail to understand what you are trying to do exactly

The Vlookup is set up in a column that shows me the dollar amount for the code which is put in the A column. Table for Vlookup is set up in the Excel spreadsheet. The problem is I can't sum the column due to the calculation remaining in the cells. I don't know if I have missed something in the calculation or in the summing. Or do I need to have the result of the calculation put in another column? I'm totally lost with trying to fix this.

 

[etaf]

sorry still dont get it

The problem is I can't sum the column due to the calculation remaining in the cells.

what column and what calculation

lets assume the value from vlookup is in column B based on values from column A
what do you want to sum
sum(B:B) should work - if your lookup table has numbers in and are returning those $ values as numbers

 

[GR00007]

ADVERTISEMENT

Could your VLOOKUP be returning a text value? If so, you could try
=VALUE(VLOOKUP(......))

 

[dvmclau]

sorry still dont get it


what column and what calculation

lets assume the value from vlookup is in column B based on values from column A
what do you want to sum
sum(B:B) should work - if your lookup table has numbers in and are returning those $ values as numbers[/Q

This is the calculation that is in the column =VLOOKUP(A2467,$U$4:$V$6,2,FALSE) this is what is returned to the column 45.00[FONT=Arial, sans-serif][COLOR=rgba(0, 0, 0, 0.847059)] [/COLOR][/FONT]
and the Vlookup calculation remains in the column too. Not every cell has a dollar amount in it being there is not code entered in column A. So with just the calculation left in and no code entered in A column it just gives the #N/A.

 

[etaf]

ADVERTISEMENT

yes .thats the correct response from vlookup when it cannot find a match

so you have a column with
45.00
#N/A

and you want to sum()
and you get #N/A in the result because of the errors

if you modified the vlookup()
=IFERROR(VLOOKUP(A2467,$U$4:$V$6,2,FALSE) ,"" )
Now instead of #N/A you get a blank cell
and now the SUM() will work

 

[dvmclau]

yes .thats the correct response from vlookup when it cannot find a match

so you have a column with
45.00
#N/A

and you want to sum()
and you get #N/A in the result because of the errors

if you modified the vlookup()
=IFERROR(VLOOKUP(A2467,$U$4:$V$6,2,FALSE) ,"" )
Now instead of #N/A you get a blank cell
and now the SUM() will work

Thank you, thank you! It worked
Wish you the best.

 

[etaf]

you are welcome