# Summing totals by column and cell

**URL:** <https://community.glideapps.com/t/summing-totals-by-column-and-cell/55480>\
**Category:** Ask for Help\
**Created:** [December 6, 2022, 6:10pm UTC](https://community.glideapps.com/t/summing-totals-by-column-and-cell/55480 "2022-12-06T18:10:39Z")\
**Posts on this page:** 4\
**Page:** 1

<div class="post-metadata">

**Author:** ![Wayne\_S](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wayne_s/32/50714_2.png) [@Wayne\_S](https://community.glideapps.com/u/Wayne_S)\
**Post date:** [December 6, 2022, 6:10pm UTC](https://community.glideapps.com/t/summing-totals-by-column-and-cell/55480/1 "2022-12-06T18:10:39Z")

</div>

Need some help with this one please.

 ![image](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/9/0/90c2c1a0d20f7c99ca3f66277c8da8321329d172.png)

How can I total each column but have the sum relate to the recipients email?

So for example, for Sarah Smith, I need a column titled Breakfast Total and the value would be 2 (as opposed to the 14 I get with rollup) based on the screen shot?

---

<div class="post-metadata">

**Author:** ![Jeff\_Hager](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/jeff_hager/32/43_2.png) [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)\
**Post date:** [December 6, 2022, 6:13pm UTC](https://community.glideapps.com/t/summing-totals-by-column-and-cell/55480/2 "2022-12-06T18:13:53Z")

</div>

Create a multiple relation linking recipient back to itself. Then create a rollup column that sums the breakfast column through that relation.

---

<div class="post-metadata">

**Author:** ![Wayne\_S](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/wayne_s/32/50714_2.png) [@Wayne\_S](https://community.glideapps.com/u/Wayne_S)\
**Post date:** [December 6, 2022, 6:17pm UTC](https://community.glideapps.com/t/summing-totals-by-column-and-cell/55480/3 "2022-12-06T18:17:23Z")

</div>

thank you! simple when you know how 😉

---

<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:** [December 7, 2022, 6:17pm UTC](https://community.glideapps.com/t/summing-totals-by-column-and-cell/55480/4 "2022-12-07T18:17:34Z")

</div>

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