# How to a SUM for each specific row and not the entire column?
**URL:** https://community.glideapps.com/t/how-to-a-sum-for-each-specific-row-and-not-the-entire-column/7084
**Category:** Ask for Help
**Created:** [April 15, 2020, 6:12am UTC](https://community.glideapps.com/t/how-to-a-sum-for-each-specific-row-and-not-the-entire-column/7084 "2020-04-15T06:12:05Z")
**Posts on this page:** 6
**Page:** 1
### Author:  [@Alexgkr](https://community.glideapps.com/u/Alexgkr)
#### Post date: [April 15, 2020, 6:12am UTC](https://community.glideapps.com/t/how-to-a-sum-for-each-specific-row-and-not-the-entire-column/7084/1 "2020-04-15T06:12:05Z")
Hello everybody!
I am blocked on my last step with something that seems so simple, but I am probably missing a step somewhere π
For a food tracker, I compute the food the user eat everyday in a tab, [Screenshot by Lightshot](https://prnt.sc/rzkx5m)
and then in another tab I want to show the results show showing the results of what you ate in a specific day. (Cal / proteins / fat etc)
I discovered to make a sum with the Roll up column option, but the problem is that it displays for the entire column (see screenshot) - [Screenshot by Lightshot](https://prnt.sc/rzkt17)
So now, I have the same sum for everyday of my calendar, versus for one specific day.
I would like the Sum to be saved on each rows, as they are days of the week. (Calendar view)
This way each days will have different sums, because the user eat different foods everyday.
Any ideas which steps should I do to make it possible?
Thanks π
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 15, 2020, 11:40am UTC](https://community.glideapps.com/t/how-to-a-sum-for-each-specific-row-and-not-the-entire-column/7084/2 "2020-04-15T11:40:50Z")
If you can create a relation column that links the day to all items consumed in that day (probably by using date), then you can use the Rollup coming against the relation and it will only sun the values that match that relation.
---
### Author:  [@Alexgkr](https://community.glideapps.com/u/Alexgkr)
#### Post date: [April 15, 2020, 11:49am UTC](https://community.glideapps.com/t/how-to-a-sum-for-each-specific-row-and-not-the-entire-column/7084/3 "2020-04-15T11:49:11Z")
OK cool let me try it π
To match that relation of all items consumed that day I should use an array column?
thanks!
---
### Author:  [@Jeff\_Hager](https://community.glideapps.com/u/Jeff_Hager)
#### Post date: [April 16, 2020, 3:13am UTC](https://community.glideapps.com/t/how-to-a-sum-for-each-specific-row-and-not-the-entire-column/7084/4 "2020-04-16T03:13:39Z")
Hard for me to say. I donβt have a complete visual how you are setting up your relation to get the items you want to sum.
---
### Author:  [@Alexgkr](https://community.glideapps.com/u/Alexgkr)
#### Post date: [April 18, 2020, 4:20pm UTC](https://community.glideapps.com/t/how-to-a-sum-for-each-specific-row-and-not-the-entire-column/7084/5 "2020-04-18T16:20:11Z")
Hi Jeff, just to give you an update. Many thanks π It worked.
I had to add a date column in my first sheet where I was entering my daily intake in order to relate it to my calendar so I could do use the Roll up sum.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [September 20, 2024, 6:42am UTC](https://community.glideapps.com/t/how-to-a-sum-for-each-specific-row-and-not-the-entire-column/7084/6 "2024-09-20T06:42:30Z")