So then you are not looking for just 1's in the Rate Build Ups...

Try:

=SUMPRODUCT('(2) Rate Build Ups'!$G17:$O17, 'Material Schedule'!$G16:$O16)/$R$9*$S$15