百度网友e1af4042014-01-21TA获得超过1.2万个赞关注D2公式=sumpro**ct((A$2:A2=A2)*(B$2:B2))-sumpro**ct((A$2:A2=A2)*(C$2:C2))或者=sumif(A$2:A2,A2,B$2:B2)-sumif(A$2:A2,A2,C$2:C2)