Excel tutorials

With the GROUPBY function we can organize data by categories, then find totals or averages.

Below in column A we have some fruits, and in column B we have a number of lets say sold fruits. We want to calculate the total sum per fruit – we can see the total in E5.

We can enter the following formula in D3:

=GROUPBY(A2:A7;B2:B7;SUM)

The first argument is the rows, and the second is the values, the third is a choice of different mathematical operations, we choose SUM in this case.

So basically we group the data by fruits (Column A), and sums the number of fruits (Column B)

We automatically get a TOTAL row at the bottom of the results.