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 ?



You can use a conditional:



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


