Forum Discussion
Using Excel online for point tracking
I am trying to use excel online to keep track of points (people are sorted into different houses, points will be tracked, Hogwarts style). I have set up excel online to have conditional formatting so...
Summing cells based on color is complicated, it requires VBA but that is not available in Excel Online.
If you create a list with names in the first column and houses in the second column, you can use the XLOOKUP function to return the house when you enter a name.
And you can use the SUMIFS function to sum points by house, if the house has been filled in consistently.
If you were able to accomplish this! I would LOVE to see it if you wouldn't mind sharing.
See the attached workbook.