i need a little more detail to understand what you are trying to do exactly
what column and what calculationThe problem is I can't sum the column due to the calculation remaining in the cells.
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.
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