Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Newbie needs help deciphering formula.
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Newbie needs help deciphering formula.
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
Newbie needs help deciphering formula.
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Match then lookup | Excel Worksheet Functions | |||
Formula Problem - interrupted by #VALUE! in other cells!? | Excel Worksheet Functions | |||
Formula checking multiple worksheets | Excel Worksheet Functions | |||
Match / Vlookup within an Array formula | Excel Discussion (Misc queries) | |||
Help with macro formula and variable | Excel Worksheet Functions |