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?