# summing a Vlookup column

#### dvmclau

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

### Excel Facts

Highlight Duplicates
Home, Conditional Formatting, Highlight Cells, Duplicate records, OK to add pink formatting to any duplicates in selected range.

#### etaf

##### Well-known Member
i need a little more detail to understand what you are trying to do exactly

#### dvmclau

##### New Member
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

##### Well-known Member
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

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

#### dvmclau

##### New Member
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

##### Well-known Member
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

##### New Member
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.

you are welcome

Replies
6
Views
233
Replies
5
Views
76
Replies
1
Views
105
Replies
47
Views
485
Replies
10
Views
646

1,195,902
Messages
6,012,202
Members
441,678
Latest member
RewtX

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back