G
Guest
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)+SUMIF($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?
=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)+SUMIF($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?