合併格二區 各項目無順序 加總 (14423)

A13:I19=SUMPRODUCT(N(LOOKUP(COLUMN(A:R),COLUMN(A:R)/($A$2:$R$2<>""),$A$2:$R$2)=LOOKUP("z",$A$12:A$12))*($A$3:$R$3=A$13)*$A4:$R4)