Formula help #Value

[zone709]

Hi so I sue this formula below and works if 2 values are found on sheet2, but if only 1 value is found lets say in I and doesn't find value in L it returns Value. Reason why I am using =0,text is because if it finds nothing I need it to return blank rather then 0.



=IF(Sheet2!I8=0,TEXT(Sheet2!I8,""),Sheet2!I8)+IF(Sheet2!L8=0,TEXT(Sheet2!L8,""),Sheet2!L8)

 

[Joe4]

This should handle all zeroes and errors:

=IF(IFERROR(Sheet2!I8+Sheet2!L8,"")=0,"",IFERROR(Sheet2!I8+Sheet2!L8,""))

 

[zone709]

hi Joe is returns 0

 

[zone709]

Joe this is it. This works thanks it takes all the annoyying errors I was getting . Guys also thanks for the help on this formula appreciate it...

 

[Joe4]

You are welcome.