> ## Documentation Index
> Fetch the complete documentation index at: https://parabola.io/docs/llms.txt
> Use this file to discover all available pages before exploring further.

# Sum by group

> The **Sum by group** step calculates the sum of all values in one or more columns. This functionality is similar to the SUMIF function in Excel.

Take a look at this [Parabola University](https://parabola.io/resources/parabola-university) video to watch the **Sum by group** step at work.

<Frame>
  <iframe src="https://www.youtube.com/embed/zxNOtE2BsK0" title="Transforming Data | Sum by group" frameborder="0" allow="accelerometer; autoplay; clipboard-write; encrypted-media; gyroscope; picture-in-picture; web-share" referrerpolicy="strict-origin-when-cross-origin" allowfullscreen />
</Frame>

## Input/output

Our input data has 39 rows of order information showing the quantity sold, food type, customer username, and payment type per order.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/T25np0t98ZhrB8ru/images/transforms/image-23.png?fit=max&auto=format&n=T25np0t98ZhrB8ru&q=85&s=ef085ffca208018c0bccb25890a3c5c6" alt="Input table with 39 rows of order data including quantity sold, food type, customer, and payment type" width="1616" height="1137" data-path="images/transforms/image-23.png" />
</Frame>

After we connect this data to the step, it'll produce an output of 9 rows that sum quantities sold per food type in the "Quantity Sold" column.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/T25np0t98ZhrB8ru/images/transforms/image-24.png?fit=max&auto=format&n=T25np0t98ZhrB8ru&q=85&s=8ddb28a29a5988faa742a9e80f955ad8" alt="Output table with 9 rows summing quantity sold per food type" width="2136" height="1224" data-path="images/transforms/image-24.png" />
</Frame>

## Default settings

Once connected to your flow, this step will auto-select a column to find the total amount per data group/category like quantity sold per food type. The result will display your grouped values and the total sum of them as a new table.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/T25np0t98ZhrB8ru/images/transforms/image-25.png?fit=max&auto=format&n=T25np0t98ZhrB8ru&q=85&s=8e875ccc879a5a090b3544e9ed837db2" alt="Sum by group default settings auto-selecting which column to sum and which to group by" width="1274" height="786" data-path="images/transforms/image-25.png" />
</Frame>

## Custom settings

If you'd like to choose other columns for your sum calculation and which rows the calculation is grouped by, you can change the auto-selected ones by clicking into the blue boxes on the left-side toolbar.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/T25np0t98ZhrB8ru/images/transforms/image-26.png?fit=max&auto=format&n=T25np0t98ZhrB8ru&q=85&s=e8d32ac1792ebe46ac54f8fe7838a04d" alt="Custom Sum by group settings with the column selectors highlighted" width="1292" height="896" data-path="images/transforms/image-26.png" />
</Frame>

You can also select multiple columns to sum and multiple rows to group by, or choose which columns to exclude.

<Frame>
  <img src="https://mintcdn.com/parabola-7119dfb0/T25np0t98ZhrB8ru/images/transforms/image-27.png?fit=max&auto=format&n=T25np0t98ZhrB8ru&q=85&s=e3321a920a736b33e3e961c37b57c58f" alt="Sum by group configured with multiple columns to sum and multiple grouping columns" width="1419" height="1008" data-path="images/transforms/image-27.png" />
</Frame>

## Related steps

* [Average by group](/product/transform/average-by-group) — compute averages instead of totals across groups.
* [Count by group](/product/transform/count-by-group) — count rows per group rather than summing values.
* [Merge duplicate](/product/transform/merge-duplicate-rows) — collapse non-numeric duplicate rows alongside summing.
* [Add running total](/product/transform/insert-running-total-column) — track cumulative totals row by row.
* [Pivot columns](/product/transform/pivot-columns) — reshape grouped output into a wide table.