# How can I calculate the total sum of row values in the sheet?

**URL:** <https://community.glideapps.com/t/how-can-i-calculate-the-total-sum-of-row-values-in-the-sheet/66002>\
**Category:** Ask for Help\
**Created:** [September 11, 2023, 3:36pm UTC](https://community.glideapps.com/t/how-can-i-calculate-the-total-sum-of-row-values-in-the-sheet/66002 "2023-09-11T15:36:48Z")\
**Posts on this page:** 6\
**Page:** 1

<div class="post-metadata">

**Author:** ![chandlers](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chandlers/32/54972_2.png) [@chandlers](https://community.glideapps.com/u/chandlers)\
**Post date:** [September 11, 2023, 3:36pm UTC](https://community.glideapps.com/t/how-can-i-calculate-the-total-sum-of-row-values-in-the-sheet/66002/1 "2023-09-11T15:36:49Z")

</div>

Row1: 5  
Row2: 2  
Row3: 3  
Total count=10

---

<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:** [September 11, 2023, 3:39pm UTC](https://community.glideapps.com/t/how-can-i-calculate-the-total-sum-of-row-values-in-the-sheet/66002/2 "2023-09-11T15:39:05Z")

</div>

> **[Rollup Column](https://www.glideapps.com/docs/automation/computed-columns/rollup-column)**
>
> Perform calculations on columns, such as count, average, and sum.

---

<div class="post-metadata">

**Author:** ![chandlers](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chandlers/32/54972_2.png) [@chandlers](https://community.glideapps.com/u/chandlers)\
**Post date:** [September 17, 2023, 10:44pm UTC](https://community.glideapps.com/t/how-can-i-calculate-the-total-sum-of-row-values-in-the-sheet/66002/3 "2023-09-17T22:44:26Z")

</div>

I have the following array:  
{Apple, banana, Apple}

How do I count the following?

Apple count = 2  
Banana count =1

---

<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:** [September 18, 2023, 12:36am UTC](https://community.glideapps.com/t/how-can-i-calculate-the-total-sum-of-row-values-in-the-sheet/66002/4 "2023-09-18T00:36:34Z")

</div>

Is it an array column in the builder, or you have it in pure text form?

I think JavaScript is the way to go here, but I’m curious if you have a table where you store all types of fruits and you can use a joined list column for this.

If you can describe more about your use case, that’d be great.

---

<div class="post-metadata">

**Author:** ![chandlers](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/chandlers/32/54972_2.png) [@chandlers](https://community.glideapps.com/u/chandlers)\
**Post date:** [October 9, 2023, 10:07pm UTC](https://community.glideapps.com/t/how-can-i-calculate-the-total-sum-of-row-values-in-the-sheet/66002/5 "2023-10-09T22:07:45Z")

</div>

I would like to investigate a little bit more as I haven’t provided all the relevant details. Thanks for your response. I appreciate that!

---

<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:** [October 9, 2023, 11:13pm UTC](https://community.glideapps.com/t/how-can-i-calculate-the-total-sum-of-row-values-in-the-sheet/66002/6 "2023-10-09T23:13:11Z")

</div>

Thanks, please let us know if you need any further help!