SUMIF, Is this the only way

[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?

 

[David McRitchie]

Hi Scott,
Look up Address Worksheet Function in your
Excel Help. I don't think you want Absolute cell
addresses at all. They will certainly make it
difficult to paste the formula to another cell.