I need to add up a column of number returned using vlookup
. When I use Sum
, it returns a blank if the vlookup returns #N/A
, as the cell has no value. Can I then get this to show a zero instread of #N/A
so the above sum
works ?
Take the 2minute tour
×
Super User is a question and answer site for computer enthusiasts and power users. It's 100% free, no registration required.



You can use a conditional:



Try wrapping your VLOOKUP formula in IFERROR function, e.g.


