# Help with a simple "Sports" Results and Rankings app **URL:** \ **Category:** Ask for Help\ **Created:** [March 26, 2025, 5:32pm UTC](https://community.glideapps.com/t/help-with-a-simple-sports-results-and-rankings-app/80982 "2025-03-26T17:32:04Z")\ **Posts on this page:** 3\ **Page:** 1
**Author:** ![Woodside500](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/woodside500/32/84589_2.png) [@Woodside500](https://community.glideapps.com/u/Woodside500)\ **Post date:** [March 26, 2025, 5:32pm UTC](https://community.glideapps.com/t/help-with-a-simple-sports-results-and-rankings-app/80982/1 "2025-03-26T17:32:04Z")
Hi. I’m a free user who is currently trying to set up a small app that charts video sports results between a group of 4 friends. The app has two simple pages. The first page shows the manually entered match results, as well as the schedule of matches that are yet to be played. The second page would be a simple ranking system which issues points based on wins and goals. I’ve created this in excel, but when i import the .xls file it only pulls in the basic data and not the formulas, which currently calculates the points earned and the rankings. I’ve attached photos of how I’ve managed this in Excel. I’m unsure as to how to recreate the formulas in Glide. Could Anyone advise? Many thanks. ![1](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/8/2/82fda4a2cd6be1aa9f8a810081501fa42c4ef1a4.jpeg) ![2](https://us1.discourse-cdn.com/flex002/uploads/glideapps/original/3X/e/b/eb3ad1cf98f95dd68cad1a2f0c7df658410a6de7.jpeg) ---
**Author:** ![nathanaelb](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/nathanaelb/32/43079_2.png) [@nathanaelb](https://community.glideapps.com/u/nathanaelb)\ **Post date:** [March 26, 2025, 5:56pm UTC](https://community.glideapps.com/t/help-with-a-simple-sports-results-and-rankings-app/80982/2 "2025-03-26T17:56:50Z")
Based on your screenshots, I would have 2 tables: A `Users` table: this is your 2nd screenshot with the list of names of the users of the app. It will have names, email addresses, perhaps an image, a role, and then a series of columns with points. You could have a separate Points table, but at this point I don’t really see the point (haha, pun intended), I would keep points in the Users table. A `Games` table: exactly as you showed it in your 1st screenshot, with a date, player 1, player 1 score, etc. Now for the formula in F2. It’s a sum of 2 SUMIF, so you’ll be storing the value of each SUMIF in a separate column. F2 = (E2 + E3 + E10 + E11) + (C8 + C9) Column 1: (E2 + E3 + E10 + E11) Column 2: (C8 + C9) In the `Users` table: 1. Create a `relation` column, match multiple, where `Name` (in the Users table) is `Player 1` in the Games table. 2. Create a `lookup` column, data source is the relation column just above, and look up the values Player 2 Score. 3. Create a `rollup` column and do a `sum` on the lookup column just above. In a nutshell, in the Users table, you are looking at the name in the row, taking that value and matching it with values in a column of another table, then where there is a match you are gathering the values, and finally you are summing them. If you manage to set that up correctly, repeat for the second SUMIF. Finally, create a `math` column to sum the two sums. Note 1: Somewhere in there perhaps you could use a `Query` column instead of the relation, but if I were you I would stick to the relation. Note 2: It is a good practice to create relations based on unique values that will never change such as a row ID. In your example, imagine you had a new player join the group and his name was “John”. It could start getting messy and confusing. Or if you decided to change the names to first name + family name, this would destroy your relation. But a relation based on row IDs (which are unique and immutable) will not break. Once you get the hang of relations, you can redo them based on row IDs. At first I would practice with names though, it’ll make it easier for you to visualize what you’re doing. ---
**Author:** ![Woodside500](https://sea2.discourse-cdn.com/flex002/user_avatar/community.glideapps.com/woodside500/32/84589_2.png) [@Woodside500](https://community.glideapps.com/u/Woodside500)\ **Post date:** [March 26, 2025, 5:59pm UTC](https://community.glideapps.com/t/help-with-a-simple-sports-results-and-rankings-app/80982/3 "2025-03-26T17:59:47Z")
> [@nathanaelb](#): > > then a series of columns with points. You could have a separate Points table, but at this point I don’t really see the point (haha), I would keep points in the Users table. Nathan, Thankyou! This looks straight forward to follow. I’ll give it a try and let you know how I get on.