SUMIF, Is this the only way
 

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?

SUMIF, Is this the only way
 

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.

---
HTH,
David McRitchie, Microsoft MVP - Excel
My Excel Pages: http://www.mvps.org/dmcritchie/excel/excel.htm
Search Page: http://www.mvps.org/dmcritchie/excel/search.htm

"Scott" wrote in message ...
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?