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.