Home Â» How to Calculate the Sum by Group in Excel

# How to Calculate the Sum by Group in Excel

You can use the following simple formula to calculate the sum of values by group in an Excel spreadsheet:

```=SUMIF(group_range, "group name", sum_range)
```

The following example shows how to use this formula in practice.

### Example: Sum by Group in Excel

Suppose we have the following dataset that shows the total points scored by 15 different basketball players:

Now suppose weâ€™d like to find the sum of the points scored, grouped by team.

To do so, we can use the =UNIQUE() function to first create a list of the unique teams. Weâ€™ll type the following formula into cell F2:

`=UNIQUE(B2:B16)`

Once we press enter, a list of unique team names will be displayed:

Next, we can use the =SUMIF() function to find the sum of points scored by players on each team.

Weâ€™ll type in the following formula into cell G2:

`=SUMIF(B2:B16, F2, C2:C16)`

Weâ€™ll then copy and paste this formula into the remaining cells in column G:

Thatâ€™s it!

Column F displays each of the unique teams and column G displays the sum of the points scored by each team.