I have the following situation:

I have a current sheet, and I have an 'Other Sheet'

I need a formula that checks to see if I5 is equal to B2:B5000 on the other sheet... I also need to see if other columns match (4 of them)... so for example, if K5 matches C2:C5000. If all criteria match, then it should all the numbers in I5 from the other sheet.

The formula should be or close to being:
=SUMPRODUCT((I5='Other Sheet '!B2:B5000)*(K5='Other Sheet
'!C2:C5000)*(O5='Other Sheet '!E2:E5000)*('Other Sheet
'!G2:G5000="2006")*(Other Sheet '!H2:H5000="1")*('Other Sheet '!I2:I5000))

This isn't adding them though. What do I need to do to the formula?