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

 |  | Salesman | Date | Amounts |  |  |  |  | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
 |  | [NAME] | 2018-06-15 00:00:00 | 1426.737465697418 |  |  |  | #[NAME]! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
 |  | Rose | 2018-01-25 00:00:00 | 52.18827406469205 |  |  |  | #[NAME]! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
 |  | [NAME] | 2018-01-15 00:00:00 | 6174.567891616197 |  |  |  | #[NAME]! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
 |  | Mario | 2018-07-10 00:00:00 | 1307.664567753454 |  |  |  | #[NAME]! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
 |  | [NAME] | 2018-02-26 00:00:00 | 1564.816352606099 |  |  |  | #[NAME]! | #REF! | #REF! | #REF! | #REF! | #REF! | #REF!
 |  | 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
 |  | [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 |  |  |  |  |  | 3056.97656194099 | 0 | 0 | 0 | 0 | 0
 |  | [NAME] | 2018-07-23 00:00:00 | 6713.293282678225 |  |  |  | [NAME] | 0 | 0 | 0 | 0 | 0 | 0 | 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] | 0 | 0 | 0 | 0 | 0 | 441.1054813283017 | 0 |  |  |  |  | 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 | 4972.679205407781 | 0 | 0 | 6692.251606192387 | 0 | 0 | 0 |  |  |  | =SUMIFS($E$4:$E$104,$C$4:$C$104,S16#,EOMONTH(--$D$4:$D$104,0)=T15#,T15#)+0
 |  | Mario | 2018-03-22 00:00:00 | 4447.03457502353 |  |  |  | Rose | 0 | 0 | 0 | 0 | 0 | 0 | 0 |  |  | [NAME]
 |  | [NAME] | 2018-07-12 00:00:00 | 5193.345164179028 |  |  |  | [NAME] | 0 | 0 | 0 | 6335.85113860759 | 0 | 0 | 0 |  |  | [NAME]
 |  | Mario | 2018-01-20 00:00:00 | 1085.976433976404 |  |  |  |  |  |  |  |  |  |  |  |  |  | Mario
 |  | [NAME] | 2018-01-16 00:00:00 | 786.0630954284945 |  |  |  |  | =MAKEARRAY(COUNTA(I13#),COUNTA(J12#),LAMBDA(r,c,SUMPRODUCT(($C$3:$C$103=INDEX(I13#,r))*($E$3:$E$103)*($D$3:$D$103=INDEX(J12#,,c))))) |  |  |  |  |  |  |  |  | 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