The most complete documentation on Excel's implementation of grouped summation

EXCEL has unique advantages in processing basic data, and grouping summation is the most basic processing data, so how do we achieve grouping and summation? This article introduces the most practical operation method.

No theory, no theory, no theory, and important things are said three times.

First, there is data similar to the following in excel:

The first method uses sumif:

The second method uses sumifs. Note the usage of sumifs here, which is somewhat different from sumif.If there are multiple conditions for grouping, it is most convenient to use sumifs.

The third method uses sumproduct. Pay attention to the use of columns, which should be specific to the cell range, such as B2:B20 and D2:D20 in the following figure, both of which must have the same range.

The fourth method uses a pivot table

This article only provides methods, if you need theoretical support, you can search by yourself.