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.

=C2+D2+E2+F2+G2+H2

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

Leave a Reply

Your email address will not be published. Required fields are marked *