加總 同區多個合併格 (12036)

N2 取不重複=IFERROR(INDEX(B:B,MATCH(,COUNTIF(N$1:N1,B$2:B$21)/($B$2:$B$21<>""),)+1),"")

O2:P5=IF($N2="","",SUMPRODUCT((LOOKUP(ROW($2:$21),ROW($2:$21)/($B$2:$B$21<>""),$B$2:$B$21)=$N2)*($J$2:$J$21="合計:")*K$2:K$21))