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"))
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"))
There are currently 1 users browsing this thread. (0 members and 1 guests)
Bookmarks