SUMPRODUCT excel question

[Grigoriy]

Hello, everyone!
Appreciate any help on the SUMPRODUCT function in the attached file (downloaded from the forum and slightly modified).
See the error cell D38: =SUMPRODUCT((Dates=D30)*(Cars=D31:H31)*(Abc=D32:D36);(CarData)).
Please, let me know at ( Do Not Write Emails Here! ) as I am very new here and do not quite know where I can possibly see the reply.

 

[bosco_yip]

Try,

In D38, enter array (CSE) formula :

=SUM(IFERROR((Dates=D30)*ISNUMBER(MATCH(D31:H31,Cars,0))*ISNUMBER(MATCH(D32:D36,Abc,0))*CarData,0))

The result of D38 return : 11

Regards

 

[Excel Wizard]

Please try

=SUMPRODUCT(CarData,(Dates=D30)*ISNUMBER(MATCH(Cars,D31:H31,)*MATCH(Abc,D32:D36,)))

 

[Grigoriy]

=SUMPRODUCT((Dates=D30)...
GREAT MANY THANKS - it works! The only matter for now is to understand THE WAY it works... Striving, struggling, pondering...