Spreadsheet: 155709d1337013306-sumproduct-for-multiple-criteria-and-or-statement-book1
Sheet: Forecast M&S Data

Client | Rep | Exp. Date | Amount Annualized | Length of Contract (yrs) | Status | Forecast y/n/best | Region
Client name | [NAME] | 2012-03-31 00:00:00 | 26208.0145 | 1 |  | best
Client name | [NAME] | 2012-03-31 00:00:00 | 20503.336 | 1 | closed | y
Client name | [NAME] | 2012-03-31 00:00:00 | 32185 | 3 | closed | y
Client name | [NAME] | 2012-03-31 00:00:00 | 7724 | 3 | closed | y
Client name | [NAME] | 2012-03-31 00:00:00 | 5083.106 | 1 | closed | y
Client name | [NAME] | 2012-03-31 00:00:00 | 4372 | 5 | closed | y
Client name | [NAME] | 2012-03-31 00:00:00 | 7149.31 | 1 | closed | y
Client name | Corinne Disalvo | 2012-03-31 00:00:00 | 5241.81 | 1 |  | y
Client name | [NAME] | 2012-03-31 00:00:00 | 8750 | 3 | closed | y
Client name | [NAME] | 2012-03-31 00:00:00 | 15072.302 | 1 | closed | y
Client name | [NAME] | 2012-03-31 00:00:00 | 15770 | 3 | closed | y
Client name | [NAME] | 2012-03-31 00:00:00 | 77453.65599999999 | 1 |  | n
Client name | [NAME] | 2012-03-31 00:00:00 | 112611 | 5 | closed | y
Client name | [NAME] | 2012-03-31 00:00:00 | 46870.00000000001 | 1 |  | n
Client name | [NAME] | 2012-04-30 00:00:00 | 2064.394600000001 | 1 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 5400.514 | 1 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 7169.4314 | 1 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 4765.697999999999 | 1 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 33713.91800000001 | 1 |  | best
Client name | [NAME] | 2012-04-30 00:00:00 | 5073.96 | 1 | closed | y
Client name | [NAME] | 2012-04-30 00:00:00 | 2373.1044 | 1 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 5989.0377 | 1 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 20707.82 | 1 | closed | y
Client name | [NAME] | 2012-04-30 00:00:00 | 6346.568600000001 | 1 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 20936.72 | 1 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 2998.372 | 1 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 9361.465000000002 | 1 | closed | y
Client name | [NAME] | 2012-04-30 00:00:00 | 36376.78799999999 | 1 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 20674.248 | 1 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 4603.942 | 1 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 45940.23 | 1 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 3493.014 | 1 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 35877.786 | 1 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 4952.28 | 5 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 3690.849 | 1 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 42792.092 | 1 |  | best
Client name | [NAME] | 2012-04-30 00:00:00 | 4606.994000000001 | 1 |  | y
Client name | [NAME] | 2012-05-31 00:00:00 | 3651.718 | 1 |  | best
Client name | [NAME] | 2012-05-31 00:00:00 | 4127.83 | 1 |  | y
Client name | [NAME] | 2012-05-31 00:00:00 | 6831.902000000002 | 1 |  | y
Client name | [NAME] | 2012-05-31 00:00:00 | 9268.956699999999 | 1 |  | best
Client name | [NAME] | 2012-05-31 00:00:00 | 14129.0051 | 5 |  | y
Client name | [NAME] French | 2012-05-31 00:00:00 | 16370.928 | 5 |  | best
Client name | [NAME] | 2012-05-31 00:00:00 | 8541.24 | 1 |  | y
Client name | [NAME] | 2012-05-31 00:00:00 | 2121.14 | 1 |  | y
Client name | [NAME] | 2011-12-31 00:00:00 | 7146.257999999999 | 1 |  | n
Client name | [NAME] | 2011-12-31 00:00:00 | 4960.1322 | 1 |  | n
Client name | [NAME] French | 2011-12-31 00:00:00 | 15414.126 | 1 |  | n
Client name | [NAME] | 2011-12-31 00:00:00 | 5400.514 | 1 |  | n
Client name | [NAME] | 2011-12-31 00:00:00 | 4395.0544 | 1 |  | n
Client name | [NAME] | 2011-12-31 00:00:00 | 62291.28 | 1 |  | n
Client name | [NAME] | 2011-12-31 00:00:00 | 3810.422 | 1 |  | n
Client name | [NAME] | 2011-12-31 00:00:00 | 13084.6652 | 1 |  | migration
Client name | [NAME] | 2011-12-31 00:00:00 | 4372 | 1 |  | n
Client name | [NAME] | 2012-02-29 00:00:00 | 8574.594000000001 | 1 | closed | y
Client name | [NAME] | 2012-02-29 00:00:00 | 19373.006 | 1 |  | n
Client name | [NAME] | 2012-02-29 00:00:00 | 7939.777999999999 | 1 |  | best
Client name | [NAME] | 2011-07-31 00:00:00 | 2211.25 | 1 |  | n
Client name | [NAME] | 2011-07-31 00:00:00 | 2211.25 | 1 |  | n
Client name | [NAME] | 2011-07-31 00:00:00 | 6893.75 | 1 |  | n
Client name | [NAME] | 2011-07-31 00:00:00 | 24406.36 | 1 |  | n
Client name | [NAME] | 2011-07-31 00:00:00 | 16347.5 | 1 |  | n
Client name | Corinne Disalvo | 2011-07-31 00:00:00 | 10413.75 | 1 |  | n
Client name | [NAME] | 2011-07-31 00:00:00 | 5515.08 | 4 |  | n
Client name | [NAME] | 2011-07-31 00:00:00 | 66285 | 1 |  | n
Client name | [NAME] | 2011-07-31 00:00:00 | 4293.75 | 1 |  | n
Client name | [NAME] | 2011-07-31 00:00:00 | 5333.75 | 1 |  | n
Client name | [NAME] | 2011-07-31 00:00:00 | 2154 | 3 |  | n
Client name | [NAME] | 2011-07-31 00:00:00 | 1430 | 1 |  | n
Client name | [NAME] | 2011-12-31 00:00:00 | 104200.13 | 5 |  | n
Client name | [NAME] | 2011-07-31 00:00:00 | 87487.5 | 1 |  | n
Client name | Corinne Disalvo | 2011-08-31 00:00:00 | 4954.6 | 1 |  | n
Client name | Corinne Disalvo | 2011-08-31 00:00:00 | 5831.000000000001 | 1 |  | n
Client name | [NAME] | 2011-08-31 00:00:00 | 11978 | 5 |  | n
Client name | [NAME] | 2011-08-31 00:00:00 | 32919 | 3 |  | n
Client name | [NAME] | 2011-08-31 00:00:00 | 15132.61 | 1 |  | n
Client name | [NAME] French | 2011-08-31 00:00:00 | 13261 | 5 |  | best
Client name | [NAME] | 2011-08-31 00:00:00 | 6314.37 | 1 |  | n
Client name | [NAME] | 2011-08-31 00:00:00 | 4226.25 | 1 |  | n
Client name | [NAME] French | 2011-08-31 00:00:00 | 10408.65 | 3 |  | n
Client name | [NAME] | 2012-03-31 00:00:00 | 438303 | 5 |  | y
Client name | [NAME] | 2011-09-30 00:00:00 | 5331.25 | 1 |  | n
Client name | [NAME] | 2011-09-30 00:00:00 | 3121.25 | 1 |  | best
Client name | [NAME] | 2011-09-30 00:00:00 | 3446.25 | 1 |  | n
Client name | [NAME] | 2011-09-30 00:00:00 | 2601.25 | 1 |  | n
Client name | [NAME] French | 2011-09-30 00:00:00 | 20600 | 5 |  | y
Client name | [NAME] | 2011-09-30 00:00:00 | 2861.25 | 1 |  | n
Client name | [NAME] | 2011-10-31 00:00:00 | 2127.5492 | 1 |  | n
Client name | [NAME] French | 2011-10-31 00:00:00 | 32706.54000000001 | 1 |  | n
Client name | [NAME] | 2011-10-31 00:00:00 | 4439.134 | 1 |  | n
Client name | [NAME] | 2012-03-31 00:00:00 | 4305 | 3 | closed | y
Client name | [NAME] | 2011-11-30 00:00:00 | 3334.31 | 1 |  | n
Client name | [NAME] | 2012-01-31 00:00:00 | 18359 | 3 |  | y
Client name | [NAME] | 2011-12-31 00:00:00 | 3664.1 | 1 | closed | y
Client name | [NAME] | 2011-12-31 00:00:00 | 12585 | 5 | closed | y
Client name | [NAME] | 2012-03-31 00:00:00 | 3607 | 3 | closed | y
Client name | [NAME] | 2011-12-31 00:00:00 | 133852 | 3 |  | n
Client name | [NAME] | 2012-04-30 00:00:00 | 40693.8016359 | 1 | closed | y
Client name | [NAME] | 2012-04-30 00:00:00 | 34989 | 1 |  | best
Client name | [NAME] | 2012-03-31 00:00:00 | 26429.7727029 | 1 | closed | y
Client name | [NAME] | 2012-03-31 00:00:00 | 27052.176141 | 1 |  | y
Client name | [NAME] Low | 2012-05-23 00:00:00 | 11541.22 | 1 | closed | y
Client name | [NAME] Low | 2012-04-30 00:00:00 | 25068.1436996 | 1 |  | best
Client name | [NAME] Low | 2012-05-31 00:00:00 | 118734.01985 | 1 |  | y
Client name | [NAME] | 2012-05-31 00:00:00 | 16507.9653274 | 1 |  | y
Client name | [NAME] | 2012-04-30 00:00:00 | 113230.5629206 | 1 |  | y
Client name | [NAME] | 2012-03-31 00:00:00 | 48943 | 1 |  | y
Client name | [NAME] | 2012-05-08 00:00:00 | 23350.15 | 1 |  | best
Client name | [NAME] | 2012-04-17 00:00:00 | 6848.0944 | 1 |  | best
Client name | [NAME] | 2012-03-31 00:00:00 | 60608.98448 | 1 | closed | y
Client name | [NAME] | 2012-05-17 00:00:00 | 1782.032 | 1 |  | best
Client name | [NAME] | 2012-05-31 00:00:00 | 4322.5 | 6-Month |  | y
Client name | [NAME] | 2012-05-31 00:00:00 | 30189.5314 | 1 |  | y
Client name | [NAME] | 2012-05-31 00:00:00 | 10976.20335 | 1 |  | best
Client name | [NAME] | 2012-04-24 00:00:00 | 1156.067 | 1-Month |  | y
Client name | [NAME] | 2012-03-31 00:00:00 | 38179.90003520001 | 3-Month | closed | y
Client name | [NAME] | 2012-03-31 00:00:00 | 3885.7934198 | 3-Month |  | y
Client name | [NAME] | 2012-04-12 00:00:00 | 8776.065186 | 3-Month | closed | y
Client name | [NAME] | 2012-04-18 00:00:00 | 10260.5776 | 1 | closed | y
Client name | [NAME] | 2012-04-19 00:00:00 | 83608.8989091 | 1 |  | y
Client name | [NAME] | 2012-04-27 00:00:00 | 18737.0504898 | 1 |  | y
Client name | [NAME] | 2012-04-27 00:00:00 | 9346.7176174 | 1 | closed | y
Client name | [NAME] | 2012-05-25 00:00:00 | 1156.067 | 1-Month |  | y
Client name | [NAME] | 2012-05-01 00:00:00 | 34356.45102309999 | 3-Month |  | y
Client name | [NAME] | 2012-05-05 00:00:00 | 48218.75583279999 | 1 |  | y
Client name | [NAME] | 2012-05-13 00:00:00 | 8481.5275843 | 1 |  | n
Client name | [NAME] | 2012-05-18 00:00:00 | 11269.7299749 | 1 |  | y
Client name | [NAME] | 2012-05-21 00:00:00 | 23143.200176 | 1 |  | y
Client name | [NAME] | 2012-05-27 00:00:00 | 11809.74989 | 1 |  | n
Client name | [NAME] | 2012-05-30 00:00:00 | 23812.247678 | 1 |  | y
Client name | [NAME] | 2012-05-31 00:00:00 | 16014.9225831 | 1 |  | y
Client name | [NAME] | 2012-06-25 00:00:00 | 1156.067 | 1-Month |  | y
Client name | [NAME] | 2012-06-26 00:00:00 | 2658.0292464 | 3-Month |  | y
Client name | [NAME] | 2012-06-03 00:00:00 | 140419.4290792 | 1 |  | y
Client name | [NAME] | 2012-06-30 00:00:00 | 12866.3005407 | 1 | closed | y
Client name | [NAME] | 2012-03-21 00:00:00 | 65670.5214144 | 1 | closed | y
Client name | [NAME] | 2012-01-31 00:00:00 | 67379 | 1 |  | n
Client name | [NAME] | 2012-01-31 00:00:00 | 29966.5 | 1 |  | best
Client name | [NAME] | 2012-02-16 00:00:00 | 22098 | 1 |  | n
Client name | [NAME] | 2011-08-30 00:00:00 | 59731 | 1 |  | n