# Highest scores for players

**URL:** <https://community.glideapps.com/t/highest-scores-for-players/81717>\
**Category:** Ask for Help\
**Created:** [May 5, 2025, 4:35pm UTC](https://community.glideapps.com/t/highest-scores-for-players/81717 "2025-05-05T16:35:22Z")\
**Posts on this page:** 2\
**Page:** 1

<div class="post-metadata">

**Author:** ![Matt\_Taylor](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/matt_taylor/32/83689_2.png) [@Matt\_Taylor](https://community.glideapps.com/u/Matt_Taylor)\
**Post date:** [May 5, 2025, 4:35pm UTC](https://community.glideapps.com/t/highest-scores-for-players/81717/1 "2025-05-05T16:35:22Z")

</div>

I am brand new to Glide and trying to create an app capturing the best 5 golf scores from the last 10 rounds of each player but I can’t seem to do this. If I create an array and then slice this at top 5 you can’t do a sum of it as it gets converted to text.

Can anyone suggest how this can be done? Essentially I want to do the equivalent of excel function =SUM(LARGE(A1:A10,{1,2,3,4,5})).

---

<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:** [May 5, 2025, 4:42pm UTC](https://community.glideapps.com/t/highest-scores-for-players/81717/2 "2025-05-05T16:42:26Z")

</div>

I would create a query, sort it appropriately by score, and limit it to 5 results. Then do a roll-up against that query. This is assuming each score is in individual rows.