This is the formula I used.
=SUMIF($I$29:$M$29,""&0,$B$52:$F$52)+SUMIF($I$32: $M$32,""&0,$B$54:$F$54)+SUMIF($I$35:$M$35,""&0,$ B$56:$F$56)+SUMIF($I$38:$M$38,""&0,$B$58:$F$58)+S UMIF($I$41:$M$41,""&0,$B$60:$F$60).

As you can see the cells I want to sum are in every other row and the range
with the criteria is in every third row. This formula works but will be a
real pain to enter as more rows are added. Is there another formula that
would be simpler to enter?