Adding Cells, Get Error.

[GEM]

I have a simple forumla, =A1+B1+C1+D1

Every cell, A1, B1, C1 and D1 have vlookup functions. Some of them are
blank, because information is still not entered for the vlookup function to
find.

My question is this, cell E1 has the simple formula =A1+B1+C1+D1, but if I
have no information on any of the four cells which have the vlookup function
I get #VALUE!. How can I leave E1 blank instead of having #VALUE!???

 

[T. Valko]

Try it like this:

=IF(COUNT(A11),SUM(A11),"")

 

[Keith Faulconer]

In your vlookup cells, enter the formula

=if(iserror(vlookup(.......)),0,vlookup(.....))

That way, if the vlookup returns an error, the formula will enter a 0
instead of an error, and your sum function will work.