Spreadsheet: 137121d1326971374-sumproduct-for-ytd-calculation-help-aaa-ytd-view
Sheet: Sheet1

 |  |  |  |  |  | Acutal data |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  |  | Forcasted
 |  |  | 2012-01-01 00:00:00 |  |  |  | 2012-02-01 00:00:00 |  |  |  | 2012-03-01 00:00:00 |  |  |  | 2012-04-01 00:00:00 |  |  |  |  | 2012-01-01 00:00:00 |  |  |  | 2012-02-01 00:00:00 |  |  |  | 2012-03-01 00:00:00 |  |  |  | 2012-04-01 00:00:00
 | VOLUME | CURR | CHARGE |  | VOLUME | CURR | CHARGE |  | VOLUME | CURR | CHARGE |  | VOLUME | CURR | CHARGE |  |  | VOLUME | CURR | CHARGE |  | VOLUME | CURR | CHARGE |  | VOLUME | CURR | CHARGE |  | VOLUME | CURR | CHARGE
 | 50 | GBP | 6186 |  | 24 | GBP | 3688 | 88512 | 50 | GBP | 5241 |  | 47 | GBP | 961 |  |  | 50 | GBP | 7759 |  | 24 | GBP | 6592 |  | 50 | GBP | 2967 |  | 47 | GBP | 9425
 | 76 | GBP | 2271 |  | 100 | GBP | 3526 |  | 74 | GBP | 8010 |  | 20 | GBP | 8844 |  |  | 76 | GBP | 8409 |  | 100 | GBP | 3951 |  | 74 | GBP | 7004 |  | 20 | GBP | 906
 | 35 | GBP | 9139 |  | 77 | GBP | 1027 |  | 64 | GBP | 6824 |  | 17 | GBP | 3202 |  |  | 35 | GBP | 1064 |  | 77 | GBP | 3316 |  | 64 | GBP | 363 |  | 17 | GBP | 925
 | 95 | GBP | 8590 |  | 34 | GBP | 5012 |  | 39 | GBP | 8970 |  | 63 | GBP | 9320 |  |  | 95 | GBP | 3595 |  | 34 | GBP | 2901 |  | 39 | GBP | 62 |  | 63 | GBP | 9715
 | 74 | GBP | 6569 |  | 39 | GBP | 7944 |  | 12 | GBP | 7638 |  | 90 | GBP | 792 |  |  | 74 | GBP | 6542 |  | 39 | GBP | 3895 |  | 12 | GBP | 1431 |  | 90 | GBP | 808
 | 71 | GBP | 7686 |  | 3 | GBP | 8971 |  | 85 | GBP | 2461 |  | 3 | GBP | 2972 |  |  | 71 | GBP | 8202 |  | 3 | GBP | 1192 |  | 85 | GBP | 1015 |  | 3 | GBP | 9965
 | 57 | GBP | 2949 |  | 3 | GBP | 8350 |  | 18 | GBP | 7133 |  | 57 | GBP | 3277 |  |  | 57 | GBP | 1900 |  | 3 | GBP | 725 |  | 18 | GBP | 4141 |  | 57 | GBP | 9903
 | 74 | GBP | 3075 |  | 20 | GBP | 5938 |  | 76 | GBP | 8707 |  | 64 | GBP | 6458 |  |  | 74 | GBP | 8912 |  | 20 | GBP | 2817 |  | 76 | GBP | 6698 |  | 64 | GBP | 1462
 | 84 | GBP | 1995 |  | 11 | GBP | 5321 |  | 68 | GBP | 4517 |  | 69 | GBP | 1769 |  |  | 84 | GBP | 4661 |  | 11 | GBP | 9636 |  | 68 | GBP | 4640 |  | 69 | GBP | 4229
 | 14 | GBP | 6249 |  | 69 | GBP | 5978 |  | 77 | GBP | 2832 |  | 80 | GBP | 8901 |  |  | 14 | GBP | 4799 |  | 69 | GBP | 7087 |  | 77 | GBP | 3608 |  | 80 | GBP | 9053
 | 4 | GBP | 707 |  | 6 | GBP | 4498 |  | 48 | GBP | 8223 |  | 45 | GBP | 4987 |  |  | 4 | GBP | 1724 |  | 6 | GBP | 2844 |  | 48 | GBP | 2596 |  | 45 | GBP | 4275
 | 35 | GBP | 4018 |  | 71 | GBP | 9278 |  | 31 | GBP | 3901 |  | 22 | GBP | 9257 |  |  | 35 | GBP | 6798 |  | 71 | GBP | 1453 |  | 31 | GBP | 7286 |  | 22 | GBP | 4139
 |  |  | 59434 |  |  |  | 69531 |  |  |  | 74457 |  |  |  | 60740 |  |  |  |  | 64365 |  |  |  | 46409 |  |  |  | 41811 |  |  |  | 64805
Enter Actual Month Here |  |  | 2012-02-01 00:00:00 |  | Calculation result should be |  |  | 235581 | Ideally I need the calculation to be flexable as the data can grow so there are no totals for each column
The calculation needs to change according to the date entered in D19
It should calculate up to and including the Actual month then calculate the months after the date from the Forecast section.