I’m wanting to add up a row of values that are pulled from a vlookup in another spreadsheet. Some of these values will result in a blank because the lookup cell is blank. I’m looking for a formula that will add up the values of the cells in the rows even if one cell is blank. Right now when I try to add them I get a #VALUE! error.
This results in the #VALUE error because one of the cells results in a blank from the VLOOKUP. This is the formulat I am using for the lookup:
=IFERROR(VLOOKUP(A2,’Weekly Time Card’!A3:F43,6,FALSE),”0 “)