I want to use autofill to increase
=SUMIF(WEEK1!$C$7:$L$7,"100",WEEK1!$C$298:$L$298) to

=SUMIF(WEEK2!$C$7:$L$7,"100",WEEK2!$C$298:$L$298)

=SUMIF(WEEK3!$C$7:$L$7,"100",WEEK3!$C$298:$L$298) ect ect....


Thanx:)


--
Grimzby
------------------------------------------------------------------------
Grimzby's Profile: http://www.excelforum.com/member.php...o&userid=23905
View this thread: http://www.excelforum.com/showthread...hreadid=375420