请帮忙列一下excel计算公式！！！急急急。邮箱：[email protected]

Question

如题所述

Answer 1

C2公式:
=IF(COUNTIF($A2:A$65535,A2)=1,SUMIF($A$2:$A$65535,A2,$B$2:$B$65355),"")

向下填充