Adding Cells, Get Error.
 

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!???

Adding Cells, Get Error.
 

Try it like this:

=IF(COUNT(A1:D1),SUM(A1:D1),"")

--
Biff
Microsoft Excel MVP


"GEM" wrote in message
...
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!???

Adding Cells, Get Error.
 

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.
"GEM" wrote in message
...
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!???