This is for a small personal project
I have a sheet which has a table in which depending on the teams time, points 1,3 or 5 is awarded to them
I have a sheet with a cell that has a formula that looks at another cell for the result and displays this result.
I have another sheet that has a leaderboard setup which I am trying to sum up all the games results. However the sum function only sees the formula not the actual points which is displayed.
I've looked but not sure if I'm working my query properly.
I appreciate any help... Thanks
John
I have a sheet which has a table in which depending on the teams time, points 1,3 or 5 is awarded to them
I have a sheet with a cell that has a formula that looks at another cell for the result and displays this result.
I have another sheet that has a leaderboard setup which I am trying to sum up all the games results. However the sum function only sees the formula not the actual points which is displayed.
I've looked but not sure if I'm working my query properly.
I appreciate any help... Thanks
John