I need help simplifying the following formula. It screams for sumproduct or an array formula but i just cant figure it out. Any help would be greatly appreciated.

= A1*INT(OR(A2:A5)) + B1*INT(OR(B2:B5)) + C1*INT(OR(C2:C5)) + ...

The issue comes down to using OR in an array formula or creating the same functionality. Again, any help would really be appreciated.

Thanks.