Adding Cells, Get Error.

G

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

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.
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top