☰

对具有重复标题的记录添加总和

tag-icon • tag-icon microsoft-excel worksheet-function
对具有重复标题的记录添加总和

我有一个电子表格，里面有需要添加的相同学校名称的数量。并非所有学校名称都相同，因此需要添加。

我的数据有 3000 行，下面是我的数据示例。

我需要一种方法来自动化，以便我可以得到阿比林独立学区的总数量 629（399+230=629）。我需要所有重复学校名称的总和。

 **QTY  Schoolname**
+693    7th Street Elementary School
+612    Aberdeen Elementary School
+399    Abilene Ind School District
+230    Abilene Ind School District
+431    Abraham Lincoln Elem School
+630    AcadeMir Charter School West
+212    ACADEMY ADVENTURES MIDTOWN
+715    Academy Ind School District
+345    Academy Of Dover Charter Sch
+372    Addison Elementary School
+434    Advance Public School
+1,040  ADVANTAGE ACADEMY ADMIN OFFICE
+330    Agape Inc
+240    AHFACHKEE SCHOOL
+555    Aiken Co Public Schools
+480    Aiken Co Public Schools
+400    Alachua Elementary School
+309    Alamance-Burlington Sch Dist
+530    Alamo City School
+536    Alamo City School District
+280    Alamo City School District
+300    Albert Einstein Endeavor Aca
+775    Albertville City School Dist
+273    Alexander II Magnet School
+242    Alexandria City Pub Sch Dist
+600    Algonac Cmty School District
+347    Algonac Cmty School District
+241    Algonac Cmty School District

答案1

选择表，转到插入>数据透视表。

在数据透视表中，选择 Schoolname 作为行标签并选择 QTY 作为值（默认为总和）。

相关内容