Question about * in array formula

[CasperA]

Can anyone explain why there is an asterisk (multiplication) in the following array formula that sums all the values in Column A when the value on the same row in Column B is 150 and the value in Column C is the letter U. What is being multiplied and why?

Thank you in advance,
CA

=SUM((A1:A5)*(B1:B5=150)*(C1:C5="U"))

 

[gaz_chops]

Where it finds a match it is multiplying by 1, so

A2*1*1=A2
A3*0*1=0
etc

 

[CasperA]

Thanks! So I understand that here it would be:

A1*1*1=A1=8
A2*0*0=0
A3*0*0=0
A4*1*1=A4=7
A5*0*0=0

Sum = 15

 

[gaz_chops]

Correct, effectively True=1, False=0

Depending on your version of Excel, sumifs can do the same but is none array.

=SUMIFS(A1:A5,B1:B5,150,C1:C5,"U")