I want a split bill calculator based on multiple users

The spreadsheet I have is set correctly, now I want to show points and percentages based on user input.


User 1 fills in how much they have paid for gas, tax, electricity, water and rent and now I want them to see how many points they have and percentage.

The point of the app is so flat mates see what parts of bills are paid in total

For the points, you can use a math column to sum all cols from Gas to Water.

For the percentage, first, make a rollup column on the points column to get the sum. Then make a math col, divide points by rollup total times 100 to get the percentage.