Thread: Newbie needs help deciphering formula.
View Single Post
  #1   Report Post  
Posted to microsoft.public.excel.worksheet.functions
Grimzby
 
Posts: n/a
Default 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

Reply With QuoteReply With Quote