A列,含有 小计的,对应E列求和?=SUMPRODUCT((ISNUMBER(FIND("小计",$A$2:$A$100)))*($E$2:$E$100))
=SUMPRODUCT((RIGHT(A2:A8,3)="小计)")*E2:E8)
用公式:=E3+E5+E8