Average two sums?

kyle4 · 2021-01-19T02:28:37.020Z

I have a golf app in which players can be entered as either player 1 or player 2 in the database.

(Depends on who submits the match data, if they do they are player 1, if their opponent does they are player 2)

I have a hole by hole stats page on which I want to display an average score per golf hole (for the same golf course, all of this is on one golf course presently).

Trying to write the formula for this but having trouble. In “coding” terms it looks something like this:

player 1 = NAME then hole 1 (sum)
+
player 2 = NAME then hole 1 (sum)

I need to sum the to options by finding the user’s name and then adding to a total when found…the finally averaging the total sum product. Very basic math but this is hard in bubble. Attached are some screenshots of my current status, anyone that can help me would be much appreciated!

Screen Shot 2021-01-18 at 9.18.27 PM1920×1237 276 KB

Screen Shot 2021-01-18 at 9.20.40 PM2123×1226 285 KB

Screen Shot 2021-01-18 at 9.20.44 PM2023×1243 295 KB

kyle4 · 2021-01-19T23:17:10.770Z

Does anyone know how to do this?