# Sum up all the columns

**URL:** <https://forums.knack.com/t/sum-up-all-the-columns/18885>\
**Category:** Ask Developers\
**Created:** [March 6, 2025, 3:38pm UTC](https://forums.knack.com/t/sum-up-all-the-columns/18885 "2025-03-06T15:38:45Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![IT14](https://avatars.discourse-cdn.com/v4/letter/i/b19c9b/32.png) [@IT14](https://forums.knack.com/u/IT14)\
**Post date:** [March 6, 2025, 3:38pm UTC](https://forums.knack.com/t/sum-up-all-the-columns/18885/1 "2025-03-06T15:38:45Z")

</div>

I would like to sum up all the columns and add this amount to a new/another column. The “column summaries” feature does this but I would like this number to added to another column. I tried using the equation field type but not able to figure out what would be the equation for this.

---

<div class="post-metadata">

**Author:** ![StephenChapman](https://sea2.discourse-cdn.com/flex020/user_avatar/forums.knack.com/stephenchapman/32/1759_2.png) [@StephenChapman](https://forums.knack.com/u/StephenChapman)\
**Post date:** [March 6, 2025, 8:02pm UTC](https://forums.knack.com/t/sum-up-all-the-columns/18885/2 "2025-03-06T20:02:20Z")

</div>

Hi @IT14,  
In my example I have 4x number fields `Qty A` through to `Qty D`.  
I then add an equation field that has this formula:  
`{Qty A} + {Qty B} + {Qty C} + {Qty D}`

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/9/97336a5077c417eddfc96341109bdea194fff869.png)

 ![image](https://us1.discourse-cdn.com/flex020/uploads/knack/original/2X/2/2fea63054e44b9fb5cb328c8e84b579b4e0e6ae6.png)

Hope that helps!