Hi!

Try:

=SUMIF(INDIRECT("Week"&ROW(1:1)&"!C7:L7"),100+ROWS ($1:1)-1,INDIRECT("Week"&ROW(1:1)&"!C298:L298"))

Biff

"Grimzby" wrote in
message ...

Thanx....both work great:).....spent hours reading and couldnt find an
answer.
The 100 is numeric value....can it be made to autofill in increments of
1 also....

Thanx again.


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