How to sum similar ranges?

Question

excel

There are many groups (1300) that combine keywords and their frequency (column G). The sizes of the groups are different, somewhere 2 keys, somewhere 20. At the end of each group, output the sum of column G for each group. How to implement it? Can I immediately have some ready-made solution (formula)?

Answer 1

1. Normalize the table, i.e.:
- remove gaps between groups
- remove group headings by moving this text to each line of a separate column:
now:
Group A
xyz
mno
Group B
qwe
rty
Need to:
Group A xyz
Group A mno
Group B qwe
Group B rty
2. Further, according to taste, options:
- a separate table with the names of the groups and the sum for each using sumif:
Group A sumif (range_of_column_of_table_with_data_where_Group_is_specified; "Group_A";range_of_column_of_table_with_data_where_it_is_specified_what_to_sum_to_sum)
Group B sumif (range_of_table_column_with_data_where_Group_is_specified; "Group_B",
range_of_column_of_table_with_data_where_it_is_to_be_summed) - the built-in Excel Subtotal mechanism - select the table (groups must go in a row, i.e. if they are apart, it needs to be sorted by this column first), specify what to summarize, it itself adds subtotals by groups and grand total
- pivot tables