去重汇总

=IFERROR(INDEX($F$2:$F$12,MATCH(,COUNTIF(G$1:G1,$F$2:$F$12),)),"")

=if(countif($b$2:b2,e2)=1,sumif(b:b,e2,c:c), " "),也行