# Column Addition

**URL:** <https://community.glideapps.com/t/column-addition/70981>\
**Category:** Ask for Help\
**Created:** [February 20, 2024, 2:30am UTC](https://community.glideapps.com/t/column-addition/70981 "2024-02-20T02:30:41Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![Tre\_Guerrero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tre_guerrero/32/70314_2.png) [@Tre\_Guerrero](https://community.glideapps.com/u/Tre_Guerrero)\
**Post date:** [February 20, 2024, 2:30am UTC](https://community.glideapps.com/t/column-addition/70981/1 "2024-02-20T02:30:41Z")

</div>

I would like to have a column B that would sum up 14 rows at a time from column A. so for example:

Column B should sum up rows 1-14, 15-28, 29-32, etc. from column A.

is this possible?

thanks

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 20, 2024, 11:37pm UTC](https://community.glideapps.com/t/column-addition/70981/2 "2024-02-20T23:37:28Z")

</div>

I think doing this in another table would make more sense, but can I know more about your use case?

My idea is having another table with an “index” column, starting from 0, then, 1, 2, etc.

In your current table, have a math column that’s also called index. You would use a formula like: FLOOR((A-1)/15) with A being the row index of each row, also starting from 0.

So for row 1 to 14 (index 0 to 13) you get 0, 15 to 28 (index 14 to 27) you get 1 and so on.

Create a relation based on those indexes, and a rollup to sum.

---

<div class="post-metadata">

**Author:** ![Tre\_Guerrero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tre_guerrero/32/70314_2.png) [@Tre\_Guerrero](https://community.glideapps.com/u/Tre_Guerrero)\
**Post date:** [February 21, 2024, 4:20am UTC](https://community.glideapps.com/t/column-addition/70981/3 "2024-02-21T04:20:27Z")

</div>

The use case is I have a counter that increments by 1 for each logged in user (using row ID, query, and lookup to increment). Once the logged in user gets to 14 entries (each entry is a numbered value), I would like to do a roll up on those 14 entries. Then on their next 14 entries, I would like to do a roll up on those 14 entries and etc.

So for the formula you state below, is “A” the index from the other table or the current table? Can the index in the other table be referenced to my counter that’s already made?

---

<div class="post-metadata">

**Author:** ![ThinhDinh](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/thinhdinh/32/49_2.png) [@ThinhDinh](https://community.glideapps.com/u/ThinhDinh)\
**Post date:** [February 21, 2024, 4:23am UTC](https://community.glideapps.com/t/column-addition/70981/4 "2024-02-21T04:23:30Z")

</div>

A should be the index from the current table. You calculate that for the “grouping index”, and then go to the new table to create a relation based on that index.

---

<div class="post-metadata">

**Author:** ![Tre\_Guerrero](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/tre_guerrero/32/70314_2.png) [@Tre\_Guerrero](https://community.glideapps.com/u/Tre_Guerrero)\
**Post date:** [February 21, 2024, 5:25am UTC](https://community.glideapps.com/t/column-addition/70981/5 "2024-02-21T05:25:04Z")

</div>

Yes that worked. Thanks!

---

<div class="post-metadata">

**Author:** ![system](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/system/32/53398_2.png) [@system](https://community.glideapps.com/u/system)\
**Post date:** [February 28, 2024, 5:25am UTC](https://community.glideapps.com/t/column-addition/70981/6 "2024-02-28T05:25:26Z")

</div>

This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.