SUM formulas

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 “)



By: Keith

260 thoughts on “SUM formulas

Comments are closed.