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 video to watch the Sum by group step at work.
Input/output
Our input data has 39 rows of order information showing the quantity sold, food type, customer username, and payment type per order.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/663559c9207f91d5a1baac2c_Sum%20By%20-%20Input.png)
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.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/663559c9207f91d5a1baac2b_Sum%20By%20-%20Output.png)
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.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/663559c9207f91d5a1baac2a_Sum%20By%20-%20Showing%20Default%20Options.png)
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.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/663559c9207f91d5a1baac30_Sum%20By%20-%20Showing%20Group%20Options.png)
You can also select multiple columns to sum and multiple rows to group by, or choose which columns to exclude.
![](https://cdn.prod.website-files.com/663559c9207f91d5a1ba91e4/663559c9207f91d5a1baac22_Sum%20By%20-%20Showing%20Sum%20options.png)