不用辅助列求和

◆华佗◆

详见附件要求

loirol

=SUMPRODUCT((IFNA(TEXTBEFORE($A$3:$A$1000,"-"),)=$J3)*C3:C$1000)

=SUMIF($A$3:$A$1000,J3&"*",C3:C$1000)

mjm04

WPS-正则，一步到位的

=GROUPBY(VSTACK("行标签",REGEXP(A3:A783,"[\d.]+")),C2:G783,SUM,3,0,1)

全部编号 一次统计

==========================================
低版本
先把O2单元格 补上 总计 两字，然后K3单元格

=SUM((LEFT($A$3:$A$783,FIND("-",$A$3:$A$783)-1)=$J3)*(K$2=$C$2:$G$2)*$C$3:$G$783)

右拉下拉

hxj119

1. =GROUPBY(TEXTBEFORE(A3:A783,"-"),BYROW(C3:F783,SUM),SUM)

复制代码

hxj119

或者

1. =GROUPBY(TEXTBEFORE(A3:A783,"-"),C3:F783,SUM)

复制代码

沈默00

=GROUPBY(LEFT(A3:A783,FIND("-",A3:A783)-1),C3:F783,SUM,0,0)

朝露孤烟

，需要：需要支持FILTER函数。下拉右拉。=SUM(FILTER(C$3:C$783,LEFT($A$3:$A$783,FIND("-",$A$3:$A$783)-1)=$J3))，或者=SUMIF($A$3:$A$783,$J3&"*",C$3:C$783)，公式比较简单。

你是那块小饼干

=SUM(FILTER($C$3:$F$783,ISNUMBER(FIND($J3,$A$3:$A$783)),""))

袁勇

1. =SUMIF(A:A,J3&"-*",G:G)

复制代码

wyslw2004

=LET(s,GROUPBY(TEXTBEFORE(A3:A783,"-"),C3:F783,SUM,3,0),HSTACK(s,BYROW(DROP(s,,1),SUM)))