Array Formula doesn't work as expected

[akovner]

Hi,

I entered the following formula as an array formula:

=SUM((INDEX(Table1, MATCH(A1:A10, Table1[Column1], 0), 2) * 1) * M1:M10)

The INDEX/MATCH pair returns boolean values from Table1. The funny thing is, when I split it up, I get the right result. I split it up as follows:

=(INDEX(Table1, MATCH(A1:A10, Table1[Column1], 0), 2) * 1) * M1:M10

in cells B1:B10 (as an array) and

=Sum(B1:B10)

elsewhere.