# How to get total of rows based on a column value?

**URL:** <https://community.glideapps.com/t/how-to-get-total-of-rows-based-on-a-column-value/23643>\
**Category:** Ask for Help\
**Created:** [March 2, 2021, 8:53am UTC](https://community.glideapps.com/t/how-to-get-total-of-rows-based-on-a-column-value/23643 "2021-03-02T08:53:34Z")\
**Posts on this page:** 1\
**Showing post:** 8

<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:** [March 7, 2021, 4:19pm UTC](https://community.glideapps.com/t/how-to-get-total-of-rows-based-on-a-column-value/23643/8 "2021-03-07T16:19:36Z")

</div>

Your rollup column is pointing to the sheet, so it sums everything in the sheet. You need to point it to the relation so it only sums the data with the same unique id.

---

_[View the full topic](https://community.glideapps.com/t/how-to-get-total-of-rows-based-on-a-column-value/23643)._