Spreadsheet: 162729d1340040425-sumproduct-with-multiple-criteria-to-a-calculate-a-moving-average-based-on-a-range-test2-krunk-oeldere-
Sheet: Daily Summary

 | Criteria | Aggregator / Selling Method | IMT |  |  |  |  |  |  |  | NOTES
 |  | Purchase Date | 2012-06-17 00:00:00 |  |  |  |  |  |  |  | Daily Revenue Pivot for Week Needs to be updated
 |  |  | 2011-06-17 00:00:00
 |  | Month | June
 |  | Week | Week 3
 |  | Select Day of Week | Sunday
 | Revenue | Performance Metrics | Actuals | LY Actuals | YOY Growth | Budget | Budget to Act Var.
 |  | Today's Sales Revenue | 0 | 4827 | -1 | 2252.741657534875 | -1
 |  | Average Daily Revenue | 4013.333333333333 | 3573 | 0.123239108125758 | 2875.565000000001 | 0.3956677499320421
 |  | Actual Weekly Sales Revenue | 0 | 21385 | -1 | 18340.57115299033 | -1
 |  | Average Sales Volume Week | 12878 | 12877 | 7.765783955890347e-05 |  | 0
 |  | 2MTD Sales Revenue | 68565 | 25668.3 | 1.671193651313098 | 45316.985 | -0.2051996738032353
 |  |  |  |  | 0 | 86266.95000000001
 |  | 1YTD Sales Revenue | 758285 | 414335 | 0.830125381635633 | 435759.4500000001 | 0.7401458534060474
 |  | Avg.Trip Cost Per Insureds (Monthly) | 1879.052 | 1872.009296148738 | 0.00376210944344683
 |  | [NAME]. TC as % of RPI | 0.05501710436965023 | 0.05851848331078593 | -0.05983372676527203
 | Insureds | Today's Sales Insureds | 0 | 35 | -1 | 8.61749194780282 | -1
 |  | Average Daily Insureds | 38.66666666666666 | 36.83333333333334 | 0.04977375565610846 | 11 | 2.515151515151515
 |  | Average Weekly Insureds | #N/A | ?? | 0 | 76.74418604651163 | 0
 |  | MTD Insureds | 500 | 438 | 0.1415525114155251 | 187 | 1.67379679144385
 |  | YTD Insureds | 12763 | 4088 | 2.12206457925636 | 2000 | 5.3815 |  |  |  |  |  |  |  |  |  |  | June
 | Summary | Aggregator / Selling Method | Revenue |  |  | Volume
 |  |  | Current Week | MTD2 | YTD1 | Current Week | MTD2 | YTD1
 |  | QW | 0 | 2508 | 76075 | 0 | 22 | 716
 |  | IMT | 0 | 68565 | 1262076 | 0 | 500 | 12763
 |  | Web | 0 | 208994 | 5161828.54 | 0 | 1733 | 55655
 |  | Phone | 0 | 178126.95 | 4552284.9 | 0 | 1402 | 41428
 |  | MI | 0 | 0 | 1883 | 0 | 0 | 7
 |  | ATI | 0 | 7413 | 330424 | 0 | 30 | 1358
 |  | WA Web Sales | 0 | 481.67 | 21728.81 | 0 | 1 | 215
 |  | Grand Total | 0 | 466088.62 | 11406300.25 | 0 | 3688 | 112142
 |  | 1YTD - Thru previous month
 |  | 2MTD - thru # of Days in current month
 |  |  | Budget
 |  | QW | 2979.743805353023 | 7362.529999999999 | 81628.04999999999 | 11.00831256451277 | 35.13333333333333 | 303
 |  | IMT | 19420.64674821147 | 45316.985 | 522026.4000000001 | 75.0393091158167 | 187 | 2000
 |  | Web | 140611.506053643 | 338303.16625 | 3506301.2775 | 787.8410145523737 | 1894.933333333333 | 19904
 |  | Phone | 106594.7722229615 | 263547.0985 | 3019074.87 | 551.6726117667554 | 1466.533333333333 | 15116
 |  | MI | 3186.026724119992 | 7759.083333333333 | 56535.5 | 15.12446500403867 | 7.933333333333334 | 280
 |  | ATI | 25995.56435121456 | 62991.45999999999 | 680997.3975000001 | 8.652606759135264 | 52.13333333333334 | 325
 |  | WA Web Sales | 0 | 0 | 759.4649999996182 | 0.2272306501264533 | 1.7 | 18
 |  | Grand Total | 298360.1365701744 | 725280.3230833332 | 7867322.959999999 | 1448.084869604112 | 3645.366666666667 | 37946
 |  |  |  |  | 267