# Calculating a column total

**URL:** <https://community.parabola.io/t/calculating-a-column-total/1533>\
**Category:** Ask a question\
**Created:** [February 4, 2021, 3:36pm UTC](https://community.parabola.io/t/calculating-a-column-total/1533 "2021-02-04T15:36:51Z")\
**Posts on this page:** 3\
**Page:** 1

<div class="post-metadata">

**Author:** ![Andrew1](https://avatars.discourse-cdn.com/v4/letter/a/9de053/32.png) [@Andrew1](https://community.parabola.io/u/Andrew1)\
**Post date:** [February 4, 2021, 3:36pm UTC](https://community.parabola.io/t/calculating-a-column-total/1533/1 "2021-02-04T15:36:51Z")

</div>

Hi I’d like to add a summary row as the last row adding up all the values in one column. How do I do that?

---

<div class="post-metadata">

**Author:** ![daniel](https://sea2.discourse-cdn.com/flex020/user_avatar/community.parabola.io/daniel/32/732_2.png) [@daniel](https://community.parabola.io/u/daniel)\
**Post date:** [February 4, 2021, 5:26pm UTC](https://community.parabola.io/t/calculating-a-column-total/1533/2 "2021-02-04T17:26:26Z")

</div>

Hi @Andrew1 👋

The best way to do this is to use a Sum by group step. This will sum all numeric values in a column into a single row. Here’s what my mock data looks like:

 ![googlesheets](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/6/64600d5f009a4e70396ed3675afddea102016d5f.png)

After summing the column, it will look like this:

 ![summed](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/5/5436e7b408db6f9a90f8c65af8ec183226bc2625.png)

We can then use a Stack tables step to add that row to the bottom of your column as a summary flow.

 ![stacktables](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/c/cb5ebbc27009bde433bd01e003398648bb7d4049.png)

Here’s what the final flow might look like!

 ![sumbygroup](https://us1.discourse-cdn.com/flex020/uploads/parabola/original/2X/c/c357af76f81f262bb92374f4a814319fe90d34da.png)

---

<div class="post-metadata">

**Author:** ![Andrew1](https://avatars.discourse-cdn.com/v4/letter/a/9de053/32.png) [@Andrew1](https://community.parabola.io/u/Andrew1)\
**Post date:** [February 4, 2021, 7:23pm UTC](https://community.parabola.io/t/calculating-a-column-total/1533/3 "2021-02-04T19:23:34Z")

</div>

Okay thanks very much!