ᅠᅠ
Size: a a a
ᅠᅠ
ИД

=ARRAYFORMULA(IFNA(VLOOKUP(FILTER(A3:A;A3:A<>"");QUERY(SPLIT(FLATTEN(A3:A7&"♠️"&B1:D1&"♠️"&B3:D7);"♠️";;);"select Col1, sum(Col2)+"&H1&" where Col3 = TRUE group by Col1 label sum(Col2)+"&H1&"''";0);2;0);0))K
РИ
ИД
=ARRAY_CONSTRAIN(ARRAYFORMULA(IFNA(VLOOKUP(ROW(A3:A);QUERY(SPLIT(FLATTEN(ROW(A3:A7)&"♠️"&B1:D1&"♠️"&B3:D7);"♠️";;);"select Col1, sum(Col2) + "&H1&" where Col3 = TRUE group by Col1 ";0);2;0);0));COUNTA(A3:A);1)А
u
u
ИД
u
А
EN
А
EN
u
А
u
ОЖ