Spreadsheet: 272437d1382384897-create-one-large-formula-by-combining-text-from-several-cells-holy-concatenation-batman
Sheet: FormulaWriter

 | Start Date | Month | First Day | Last Day | Concatenation | Exclamation | Range 1 | Range 2 | RangeConCat2 | RangeConcat2 | Name Target | FormulaConCat |  | [NAME] | [NAME] | Concat | Reference | Iterative Concatenation
 | 2012-01-06 00:00:00 |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 2
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 3
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 4
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 5
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 6
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 7
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 8
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 9
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 10
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 11
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 12
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 13
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 14
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 15
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 16
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 17
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 18
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 19
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 20
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 21
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 22
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 23
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 24
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 25
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 26
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 27
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 28
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 29
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 30
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 31
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 32
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 33
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 34
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 35
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 36
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 37
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 38
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 39
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 40
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 41
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 42
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 43
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 44
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 45
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 46
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 47
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 48
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 49
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 50
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 51
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 52
 |  |  |  |  |  | ! | $[NAME] | $M$5:$M$9 |  |  | Summary!$C3 |  |  | M | 53
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Copy & Paste Value of S53: | [NAME]
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Next, put a = in front of the formula, in converts to this:
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Copy, Paste Values again to get actual formual: | sumifs('Jan 6-8'!$M$5:$M$9,'Jan 6-8'!$L$5:$L$9,Summary!$C3)+sumifs('Jan 13-15'!$M$5:$M$9,'Jan 13-15'!$L$5:$L$9,Summary!$C3)+sumifs('Jan 20-22'!$M$5:$M$9,'Jan 20-22'!$L$5:$L$9,Summary!$C3)+sumifs('Jan 27-29'!$M$5:$M$9,'Jan 27-29'!$L$5:$L$9,Summary!$C3)+sumifs('Feb 3-5'!$M$5:$M$9,'Feb 3-5'!$L$5:$L$9,Summary!$C3)+sumifs('Feb 10-12'!$M$5:$M$9,'Feb 10-12'!$L$5:$L$9,Summary!$C3)+sumifs('Feb 17-19'!$M$5:$M$9,'Feb 17-19'!$L$5:$L$9,Summary!$C3)+sumifs('Feb 24-26'!$M$5:$M$9,'Feb 24-26'!$L$5:$L$9,Summary!$C3)+sumifs('Mar 2-4'!$M$5:$M$9,'Mar 2-4'!$L$5:$L$9,Summary!$C3)+sumifs('Mar 9-11'!$M$5:$M$9,'Mar 9-11'!$L$5:$L$9,Summary!$C3)+sumifs('Mar 16-18'!$M$5:$M$9,'Mar 16-18'!$L$5:$L$9,Summary!$C3)+sumifs('Mar 23-25'!$M$5:$M$9,'Mar 23-25'!$L$5:$L$9,Summary!$C3)+sumifs('Mar 30-32'!$M$5:$M$9,'Mar 30-32'!$L$5:$L$9,Summary!$C3)+sumifs('Apr 6-8'!$M$5:$M$9,'Apr 6-8'!$L$5:$L$9,Summary!$C3)+sumifs('Apr 13-15'!$M$5:$M$9,'Apr 13-15'!$L$5:$L$9,Summary!$C3)+sumifs('Apr 20-22'!$M$5:$M$9,'Apr 20-22'!$L$5:$L$9,Summary!$C3)+sumifs('Apr 27-29'!$M$5:$M$9,'Apr 27-29'!$L$5:$L$9,Summary!$C3)+sumifs('May 4-6'!$M$5:$M$9,'May 4-6'!$L$5:$L$9,Summary!$C3)+sumifs('May 11-13'!$M$5:$M$9,'May 11-13'!$L$5:$L$9,Summary!$C3)+sumifs('May 18-20'!$M$5:$M$9,'May 18-20'!$L$5:$L$9,Summary!$C3)+sumifs('May 25-27'!$M$5:$M$9,'May 25-27'!$L$5:$L$9,Summary!$C3)+sumifs('Jun 1-3'!$M$5:$M$9,'Jun 1-3'!$L$5:$L$9,Summary!$C3)+sumifs('Jun 8-10'!$M$5:$M$9,'Jun 8-10'!$L$5:$L$9,Summary!$C3)+sumifs('Jun 15-17'!$M$5:$M$9,'Jun 15-17'!$L$5:$L$9,Summary!$C3)+sumifs('Jun 22-24'!$M$5:$M$9,'Jun 22-24'!$L$5:$L$9,Summary!$C3)+sumifs('Jun 29-31'!$M$5:$M$9,'Jun 29-31'!$L$5:$L$9,Summary!$C3)+sumifs('Jul 6-8'!$M$5:$M$9,'Jul 6-8'!$L$5:$L$9,Summary!$C3)+sumifs('Jul 13-15'!$M$5:$M$9,'Jul 13-15'!$L$5:$L$9,Summary!$C3)+sumifs('Jul 20-22'!$M$5:$M$9,'Jul 20-22'!$L$5:$L$9,Summary!$C3)+sumifs('Jul 27-29'!$M$5:$M$9,'Jul 27-29'!$L$5:$L$9,Summary!$C3)+sumifs('Aug 3-5'!$M$5:$M$9,'Aug 3-5'!$L$5:$L$9,Summary!$C3)+sumifs('Aug 10-12'!$M$5:$M$9,'Aug 10-12'!$L$5:$L$9,Summary!$C3)+sumifs('Aug 17-19'!$M$5:$M$9,'Aug 17-19'!$L$5:$L$9,Summary!$C3)+sumifs('Aug 24-26'!$M$5:$M$9,'Aug 24-26'!$L$5:$L$9,Summary!$C3)+sumifs('Aug 31-33'!$M$5:$M$9,'Aug 31-33'!$L$5:$L$9,Summary!$C3)+sumifs('Sep 7-9'!$M$5:$M$9,'Sep 7-9'!$L$5:$L$9,Summary!$C3)+sumifs('Sep 14-16'!$M$5:$M$9,'Sep 14-16'!$L$5:$L$9,Summary!$C3)+sumifs('Sep 21-23'!$M$5:$M$9,'Sep 21-23'!$L$5:$L$9,Summary!$C3)+sumifs('Sep 28-30'!$M$5:$M$9,'Sep 28-30'!$L$5:$L$9,Summary!$C3)+sumifs('Oct 5-7'!$M$5:$M$9,'Oct 5-7'!$L$5:$L$9,Summary!$C3)+sumifs('Oct 12-14'!$M$5:$M$9,'Oct 12-14'!$L$5:$L$9,Summary!$C3)+sumifs('Oct 19-21'!$M$5:$M$9,'Oct 19-21'!$L$5:$L$9,Summary!$C3)+sumifs('Oct 26-28'!$M$5:$M$9,'Oct 26-28'!$L$5:$L$9,Summary!$C3)+sumifs('Nov 2-4'!$M$5:$M$9,'Nov 2-4'!$L$5:$L$9,Summary!$C3)+sumifs('Nov 9-11'!$M$5:$M$9,'Nov 9-11'!$L$5:$L$9,Summary!$C3)+sumifs('Nov 16-18'!$M$5:$M$9,'Nov 16-18'!$L$5:$L$9,Summary!$C3)+sumifs('Nov 23-25'!$M$5:$M$9,'Nov 23-25'!$L$5:$L$9,Summary!$C3)+sumifs('Nov 30-32'!$M$5:$M$9,'Nov 30-32'!$L$5:$L$9,Summary!$C3)+sumifs('Dec 7-9'!$M$5:$M$9,'Dec 7-9'!$L$5:$L$9,Summary!$C3)+sumifs('Dec 14-16'!$M$5:$M$9,'Dec 14-16'!$L$5:$L$9,Summary!$C3)+sumifs('Dec 21-23'!$M$5:$M$9,'Dec 21-23'!$L$5:$L$9,Summary!$C3)+sumifs('Dec 28-30'!$M$5:$M$9,'Dec 28-30'!$L$5:$L$9,Summary!$C3)
 |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Now, just copy it into the first cell and put an = in front of it again