# Combine row of data for total
**URL:** https://community.glideapps.com/t/combine-row-of-data-for-total/80810
**Category:** Ask for Help
**Created:** [March 18, 2025, 10:01am UTC](https://community.glideapps.com/t/combine-row-of-data-for-total/80810 "2025-03-18T10:01:42Z")
**Posts on this page:** 7
**Page:** 1
### Author:  [@mrm24\_6](https://community.glideapps.com/u/mrm24_6)
#### Post date: [March 18, 2025, 10:01am UTC](https://community.glideapps.com/t/combine-row-of-data-for-total/80810/1 "2025-03-18T10:01:42Z")
Hi community. My first post. I am working on a tracker of all the football games I have attended to try find all my stats. I am currently struggling to total the amount of data into 1 specific output
I want to total the amount of yellow cards and then I want to total the amount of games so I have single total numbers to know I have seen X number of games and X number of yellow cards. Any help would be appreciated. Thanks!
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 18, 2025, 10:04am UTC](https://community.glideapps.com/t/combine-row-of-data-for-total/80810/2 "2025-03-18T10:04:15Z")
You can use Rollup Columns.
> **[Rollup Column | Glide Docs](https://www.glideapps.com/docs/automation/computed-columns/rollup-column)**
>
> Perform calculations on columns, such as count, average, and sum.
---
### Author:  [@mrm24\_6](https://community.glideapps.com/u/mrm24_6)
#### Post date: [March 18, 2025, 10:15am UTC](https://community.glideapps.com/t/combine-row-of-data-for-total/80810/3 "2025-03-18T10:15:30Z")
Thanks for the fast reply Darren. Are you sure that a Rollup will work?
I want the total number of all the yellow cards per referee put together so I have 1 total and I want the total number of all the games per referee put together so I have 1 total.
Above is an image of a breakdown of one season where I have unhidden the columns. As you can see I have used a look up to find the data per column, then used a rollup to count that data and then done a total ( 08 09 YC 1 Roll + 08 09 YC 2 Roll)
---
### Author:  [@nathanaelb](https://community.glideapps.com/u/nathanaelb)
#### Post date: [March 18, 2025, 10:20am UTC](https://community.glideapps.com/t/combine-row-of-data-for-total/80810/4 "2025-03-18T10:20:08Z")
If you want totals, averages, counts, etc.: use a rollup column which will give you the total, average, count of that entire column.
If you want **conditional** totals, averages, counts, etc. (i.e. “per something”): use a query column first to define your condition, and then do a rollup on the query column.
---
### Author:  [@Darren\_Murphy](https://community.glideapps.com/u/Darren_Murphy)
#### Post date: [March 18, 2025, 10:28am UTC](https://community.glideapps.com/t/combine-row-of-data-for-total/80810/5 "2025-03-18T10:28:33Z")
> [@mrm24\_6](#):
>
> I want the total number of all the yellow cards per referee put together so I have 1 total and I want the total number of all the games per referee put together so I have 1 total.
Well, you didn’t say that the first time.
To get that, do what Nathanael suggested.
> [@nathanaelb](#):
>
> If you want **conditional** totals, averages, counts, etc. (i.e. “per something”): use a query column first to define your condition, and then do a rollup on the query column.
---
### Author:  [@mrm24\_6](https://community.glideapps.com/u/mrm24_6)
#### Post date: [March 18, 2025, 10:53am UTC](https://community.glideapps.com/t/combine-row-of-data-for-total/80810/6 "2025-03-18T10:53:00Z")
Thanks very much Nathanael for your help that seems to have done it. Much appreicated 🙂
Thanks Darren for your help also
---
### Author:  [@system](https://community.glideapps.com/u/system)
#### Post date: [March 25, 2025, 10:53am UTC](https://community.glideapps.com/t/combine-row-of-data-for-total/80810/7 "2025-03-25T10:53:57Z")
This topic was automatically closed 7 days after the last reply. New replies are no longer allowed.