I'm afraid sumproduct can't do that.

Much better off adjusting the formulas in Column T to return a 0 instead of Div/0 errors.

Or use an array formula enterd with CTRL + SHIFT + ENTER
=SUM(IF(('5-8-13'!$E$2:$E$5000="Americas")*('5-8-13'!$H$2:$H$5000=Americas!D$6)*ISNUMBER('5-8-13'!$T$2:$T$5000),'5-8-13'!$T$2:$T$5000))