• Hi All

    Please note that at the Chandoo.org Forums there is Zero Tolerance to Spam

    Post Spam and you Will Be Deleted as a User

    Hui...

  • When starting a new post, to receive a quicker and more targeted answer, Please include a sample file in the initial post.

SUMPRODUCT excel question

Grigoriy

New Member
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.
 

Attachments

Last edited by a moderator:

bosco_yip

Excel Ninja
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
 
Top