SUMPRODUCT by Aladin is not working again

[flora1]

i have uploaded the file here

https://www.dropbox.com/s/j491r6e5s6in3qu/Aladin.xlsx?dl=0

below formula does not work.

=SUMPRODUCT(DataAMOUNT,--ISNUMBER(MATCH(DataYear,B$2)),1-ISNUMBER(MATCH(DataMonth,$A3,0)),--ISNUMBER(MATCH(LEFT(DataPRODUCT),{5,6,7}&"",0)))

 

[Joe4]

Please do not post the same question multiple times. All clarifications, follow-ups, and bumps should be posted back to the original thread. Per forum rules, posts of a duplicate nature will be locked or deleted (rule 12 here: Forum Rules).

If you do not receive a response, you can "bump" it by replying to it again, though we advise you to wait 24 hours before doing and not to bump a thread more than once a day.