Spreadsheet: 862216d1709953168-sumproduct-get-error-combine-with-makearray-and-operator-and-sumproduct-errors
Sheet: Errors while using sumproduct

 |  | Salesman | Date | Amounts
 |  | [NAME] | 2018-06-15 00:00:00 | 1426.737465697418
 |  | Rose | 2018-01-25 00:00:00 | 52.18827406469205
 |  | [NAME] | 2018-01-15 00:00:00 | 6174.567891616197
 |  | Mario | 2018-07-10 00:00:00 | 1307.664567753454
 |  | [NAME] | 2018-02-26 00:00:00 | 1564.816352606099
 |  | Rose | 2018-01-19 00:00:00 | 2978.506810287985
 |  | Mario | 2018-06-14 00:00:00 | 4540.667181534451
 |  | [NAME] | 2018-02-13 00:00:00 | 11426.52355131851
 |  | [NAME] | 2018-04-22 00:00:00 | 8599.34325422946 |  |  |  | SumPRODUCT |  |  |  |  |  |  |  |  |  |  | =SUMIFS($E$4:$E$104,$C$4:$C$104,S16#,EOMONTH(--$D$4:$D$104,0)=T15#,T15#)+0
 |  | [NAME] | 2018-02-02 00:00:00 | 4938.643843145351 |  |  |  |  |  | 2018-02-28 00:00:00 | 2018-03-31 00:00:00 | 2018-04-30 00:00:00 | 2018-05-31 00:00:00 | 2018-06-30 00:00:00 | 2018-07-31 00:00:00
 |  | [NAME] | 2018-04-02 00:00:00 | 5652.912091476707 |  |  |  |  |  | 25721.91355174623 | 3802.992498035992 | 29600.98322113931 | 21562.35423333564 | 18247.13169946 | 7519.163712792412
 |  | [NAME] | 2018-07-23 00:00:00 | 6713.293282678225 |  |  |  | [NAME] | 15732.32564661462 | 360.7107201829264 | 6829.771835561441 | 11897.98022387542 | 14631.77786612588 | 14079.5647907555 | 0 |  |  |  | I tried to use [NAME] on this.. And it not letting me even finish the formula
 |  | [NAME] | 2018-01-01 00:00:00 | 11095.95382889301 |  |  |  | [NAME] | 30546.70464517044 | 23876.83095185567 | 20891.63675367126 | 20325.27009732291 | 10841.37729706037 | 24388.94053961139 | 29069.57187537387 |  |  |  |  | 2018-02-28 00:00:00 | 2018-03-31 00:00:00 | 2018-04-30 00:00:00 | 2018-05-31 00:00:00 | 2018-06-30 00:00:00 | 2018-07-31 00:00:00
 |  | Mario | 2018-05-07 00:00:00 | 986.1568269889634 |  |  |  | Mario | 16838.93054751231 | 12913.13046291754 | 6360.167460409158 | 14265.01178682268 | 2551.751434194086 | 11438.6168972418 | 10887.35851969644
 |  | Mario | 2018-03-22 00:00:00 | 4447.03457502353 |  |  |  | Rose | 3030.695084352677 | 1983.174832448236 | 756.8973963138802 | 18639.70916656773 | 10197.44737417291 | 0 | 0 |  |  | [NAME]
 |  | [NAME] | 2018-07-12 00:00:00 | 5193.345164179028 |  |  |  | [NAME] | 0 | 1564.816352606099 | 13890.85782288278 | 6335.85113860759 | 0 | 18741.65519456683 | 6713.293282678225 |  |  | [NAME]
 |  | Mario | 2018-01-20 00:00:00 | 1085.976433976404 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mario
 |  | [NAME] | 2018-01-16 00:00:00 | 786.0630954284945 |  |  |  |  |  |  |  |  |  |  |  |  |  | Rose
 |  | [NAME] | 2018-05-14 00:00:00 | 2271.770828529447 |  |  |  |  |  |  |  |  |  |  |  |  |  | [NAME]
 |  | [NAME] | 2018-07-29 00:00:00 | 7009.883198469012
 |  | [NAME] | 2018-04-14 00:00:00 | 930.0051772665711
 |  | [NAME] | 2018-05-15 00:00:00 | 715.4090449200785
 |  | [NAME] | 2018-06-08 00:00:00 | 2737.038720904443
 |  | [NAME] | 2018-06-17 00:00:00 | 1680.228428705623
 |  | Mario | 2018-02-01 00:00:00 | 1325.157444668621
 |  | [NAME] | 2018-06-08 00:00:00 | 6605.603275038893
 |  | Rose | 2018-03-09 00:00:00 | 756.8973963138802
 |  | Mario | 2018-04-30 00:00:00 | 6692.251606192387
 |  | Mario | 2018-02-23 00:00:00 | 6169.751485034953
 |  | [NAME] | 2018-05-02 00:00:00 | 8776.721375108988
 |  | [NAME] | 2018-03-27 00:00:00 | 1935.012198869669
 |  | [NAME] | 2018-01-07 00:00:00 | 6276.654913689663
 |  | Mario | 2018-01-04 00:00:00 | 9925.572619723935
 |  | [NAME] | 2018-03-28 00:00:00 | 9169.85311166735
 |  | Rose | 2018-05-17 00:00:00 | 9377.021622200038
 |  | [NAME] | 2018-06-13 00:00:00 | 9465.82329755054
 |  | [NAME] | 2018-04-14 00:00:00 | 2511.343548606173
 |  | [NAME] | 2018-04-23 00:00:00 | 727.195390814146
 |  | [NAME] | 2018-06-08 00:00:00 | 1755.697999649834
 |  | [NAME] | 2018-03-17 00:00:00 | 4721.004711215427
 |  | Rose | 2018-05-23 00:00:00 | 820.4257519728695
 |  | Mario | 2018-01-31 00:00:00 | 4972.679205407781
 |  | [NAME] | 2018-03-13 00:00:00 | 9427.119793006064
 |  | [NAME] | 2018-04-04 00:00:00 | 5749.390057882954
 |  | [NAME] | 2018-01-20 00:00:00 | 5151.175341971837
 |  | Mario | 2018-02-21 00:00:00 | 5418.221533213969
 |  | [NAME] | 2018-07-30 00:00:00 | 7519.163712792412
 |  | [NAME] | 2018-04-02 00:00:00 | 834.4288044883704
 |  | [NAME] | 2018-06-29 00:00:00 | 8600.899198833016
 |  | Rose | 2018-04-18 00:00:00 | 8187.600843300182
 |  | [NAME] | 2018-01-18 00:00:00 | 13174.09590258777
 |  | Mario | 2018-03-26 00:00:00 | 1913.132885385628
 |  | [NAME] | 2018-04-19 00:00:00 | 8749.480959780269
 |  | [NAME] | 2018-05-06 00:00:00 | 13916.3688212058
 |  | Mario | 2018-04-19 00:00:00 | 4385.164572909939
 |  | Mario | 2018-06-21 00:00:00 | 5355.459327308317
 |  | [NAME] | 2018-04-15 00:00:00 | 821.0551750536803
 |  | [NAME] | 2018-07-20 00:00:00 | 2808.81845708871
 |  | [NAME] | 2018-04-09 00:00:00 | 6301.706417025267
 |  | [NAME] | 2018-06-30 00:00:00 | 441.1054813283017
 |  | [NAME] | 2018-04-03 00:00:00 | 3939.07323876944
 |  | [NAME] | 2018-02-05 00:00:00 | 10792.77216297026
 |  | [NAME] | 2018-02-28 00:00:00 | 3056.97656194099
 |  | [NAME] | 2018-02-05 00:00:00 | 11996.42836785383
 |  | Mario | 2018-05-16 00:00:00 | 1449.483182171142
 |  | [NAME] | 2018-06-29 00:00:00 | 1485.249000274797
 |  | Mario | 2018-05-27 00:00:00 | 116.1114250339801
 |  | [NAME] | 2018-02-07 00:00:00 | 6933.520983689637
 |  | [NAME] | 2018-06-13 00:00:00 | 9342.023716287662
 |  | [NAME] | 2018-04-15 00:00:00 | 3595.488540058318
 |  | [NAME] | 2018-02-13 00:00:00 | 453.8790326833267
 |  | [NAME] | 2018-06-27 00:00:00 | 1693.270499306851
 |  | [NAME] | 2018-06-28 00:00:00 | 10175.50212178413
 |  | [NAME] | 2018-04-04 00:00:00 | 1430.066463099649
 |  | [NAME] | 2018-03-21 00:00:00 | 3802.992498035992
 |  | [NAME] | 2018-03-13 00:00:00 | 1079.300498482126
 |  | [NAME] | 2018-07-08 00:00:00 | 13362.47691136263
 |  | [NAME] | 2018-06-07 00:00:00 | 3128.49249293016
 |  | [NAME] | 2018-03-04 00:00:00 | 6829.771835561441
 |  | [NAME] | 2018-04-25 00:00:00 | 711.9506157251626
 |  | [NAME] | 2018-06-22 00:00:00 | 5411.290738754525
 |  | [NAME] | 2018-04-30 00:00:00 | 6335.85113860759
 |  | Rose | 2018-04-12 00:00:00 | 10452.10832326754
 |  | Mario | 2018-04-04 00:00:00 | 563.9306762559977
 |  | Mario | 2018-06-11 00:00:00 | 1542.490388399033
 |  | [NAME] | 2018-06-16 00:00:00 | 9399.914532350018
 |  | [NAME] | 2018-01-09 00:00:00 | 3932.459378094485
 |  | [NAME] | 2018-05-30 00:00:00 | 7104.116593319834
 |  | Mario | 2018-04-19 00:00:00 | 2623.664931464363
 |  | [NAME] | 2018-05-26 00:00:00 | 12186.46681148636
 |  | [NAME] | 2018-07-10 00:00:00 | 695.0481442744837
 |  | Mario | 2018-07-19 00:00:00 | 9579.693951942987
 |  | Mario | 2018-01-15 00:00:00 | 854.7022884041874
 |  | [NAME] | 2018-06-20 00:00:00 | 2108.415254997501
 |  | Rose | 2018-02-19 00:00:00 | 1983.174832448236
 |  | [NAME] | 2018-01-09 00:00:00 | 4361.28900574688
 |  | [NAME] | 2018-03-09 00:00:00 | 8450.204263313406
 |  | [NAME] | 2018-04-16 00:00:00 | 11270.79380806147
 |  | [NAME] | 2018-01-27 00:00:00 | 1501.338825372924
 |  | [NAME] | 2018-05-25 00:00:00 | 2064.655921951387
 |  | [NAME] | 2018-02-25 00:00:00 | 360.7107201829264