Why can't I add IFERROR results?

I have been racking my brain over this one. I have a complex "dashboard" to pull together different costs for each product which would allow me to quick view the total cost for each product produced. I needed to do a vlookup for two different sheets and used IFERROR in my formula. But when I try to some the row of data it does not add up the values for cells with IFERROR formulas? Can someone tell me how to do this? Below is a sample of one of my IFERROR cells.

=IF(ISERROR(VLOOKUP(C33,'Creel Printing JSHQ'!$A:$T,4,0)),"",VLOOKUP(C33,'Creel Printing JSHQ'!$A:$T,4,0)) & IF(ISERROR(VLOOKUP(C33, 'Creel Printing CSX'!A:AB,3,0)),"", VLOOKUP(C33, 'Creel Printing CSX'!A:AB,3,0))

instead of "", try 0 instead... also, instead of & try +

instead of "", try 0 instead... also, instead of & try +

re-post: you can re-write your formulas to this...

=IFERROR(VLOOKUP(C33,'Creel Printing JSHQ'!$A:$T,4,0),0)+IFERROR(VLOOKUP(C33, 'Creel Printing CSX'!A:AB,3,0),0)

A sample sheet would be helpful here,

On thing I noticed right away is IFERROR is not in your formula.

ISERRROR does kind of the same thing, but you have to name the error you are looking for, and unless that first VL is a number that names an error it will all fail.

YOU are AWESOME! Thanks!! Worked like a charm

Originally Posted by djapigo

instead of "", try 0 instead... also, instead of & try +

re-post: you can re-write your formulas to this...

=IFERROR(VLOOKUP(C33,'Creel Printing JSHQ'!$A:$T,4,0),0)+IFERROR(VLOOKUP(C33, 'Creel Printing CSX'!A:AB,3,0),0)

Glad it worked... please go back to your first entry and choose "SOLVED" to close out this thread...