Ooops!

Translated:
=SUMIF(Week2!C7:L7,201,Week2!C298:L298)

Should be:

=SUMIF(Week1!C7:L7,201,Week1!C298:L298)

Biff

"Biff" wrote in message
...
Hi!

Translated:

=SUMIF(Week2!C7:L7,201,Week2!C298:L298)

The Indirect function is being used to "build" the references to the
particular sheets. The criteria is also being "built" by using the Rows
function.

When this formula is drag copied across the sheet name increments to
Week3, Week4, etc and when drag copied down the criteria increments to
202, 203, etc.

Biff

"Grimzby" wrote in
message ...

Hi trying to understand this formula can someone please break it
down....thanx
=SUMIF(INDIRECT("WEEK"&COLUMNS($B$6:B7)&"!C7:L7"), 200+ROWS($5:6)-1,
INDIRECT("WEEK"&COLUMNS($B$6:B7)&"!C298:L298"))


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