# Sum value per different line

**URL:** https://community.glideapps.com/t/sum-value-per-different-line/68340
**Category:** Ask for Help
**Created:** [December 4, 2023, 8:17am UTC](https://community.glideapps.com/t/sum-value-per-different-line/68340 "2023-12-04T08:17:59Z")
**Posts on this page:** 2
**Page:** 1

<div class="post-metadata">

### Author: ![vRCr\_Racing\_League](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/vrcr_racing_league/32/63216_2.png) [@vRCr\_Racing\_League](https://community.glideapps.com/u/vRCr_Racing_League)
#### Post date: [December 4, 2023, 8:17am UTC](https://community.glideapps.com/t/sum-value-per-different-line/68340/1 "2023-12-04T08:17:59Z")

</div>

Hi guys, I have a situation like this.  
In a table I have, line per line, every driver results, and they are repeated, for example:  
Driver 1 | 1st  
Driver 2 | 2nd  
Driver 3 | 1st  
Driver 1 | 2nd  
Driver 1 | 1st  
Driver 4 | 3rd  
Driver 2 | 2nd

Ok…I want to create a counter to show in the app, with the sum, **driver per driver** , about their podium finish, like this:  
Driver 1  
1st place: 2  
2nd place: 1  
3rd place: x

Driver 2  
1st place:…  
2nd place…

---

<div class="post-metadata">

### Author: ![AdamMartin](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/adammartin/32/66650_2.png) [@AdamMartin](https://community.glideapps.com/u/AdamMartin)
#### Post date: [December 4, 2023, 10:02am UTC](https://community.glideapps.com/t/sum-value-per-different-line/68340/2 "2023-12-04T10:02:22Z")

</div>

You can create a query column for each podium position… so 3 columns… and then use 3 rollup columns to count the entries in each of those columns…

Your query columns will match the Driver Name to “this row” driver name and position equals 1st, 2nd, 3rd
