=QUERY({統合入力!A2:C3;統合入力!E2:G3;統合入力!I2:K3},"select * where Col1 is not null label Col1 '地域', Col2 '担当', Col3 '数量'",0)

=QUERY(A1:C7,"select A, sum(C) group by A label sum(C) '数量合計'",1)

=QUERY(A1:C7,"select B, sum(C) group by B pivot A label sum(C) ''",1)
