Add Spreadsheet Settlement For Free

Enter expenses in the Expense Details tab. The Who Paid column has a drop down that shows all the names you entered in Step 1. So you can simply select the name from the list. As soon as you enter the details, it automatically shows you the expense sharing summary.

Find Per Person Cost For Expenses On Row 2, the formula is =IFERROR(B2/sum(C2:J2),"") This formula simply takes the expense paid and divides it by the SUM() of 1s in that given row.

Once you have created an expense, enter the amount in the ?Amount? column and select the name of the person who paid from the drop-down in the ?Who Paid?? column. To include people in the split for an expense, just put an ?X? in the cell under their name.

Once you have created an expense, enter the amount in the ?Amount? column and select the name of the person who paid from the drop-down in the ?Who Paid?? column. To include people in the split for an expense, just put an ?X? in the cell under their name.

Google Sheets is more user-friendly and accessible; Excel is more advanced. If you're looking for a basic spreadsheet app at no cost to you, Google Sheets has you covered. If you need more powerful tools for managing and manipulating data and don't mind dropping some cash on a spreadsheet app, Excel may be a better fit ...

With Google Sheets, you can create and edit spreadsheets directly in your web browser?no special software is required. Multiple people can work simultaneously, you can see people's changes as they make them, and every change is saved automatically. Google Workspace account?Don't have one?

In this situation, where every expense is split equally; that is, 50/50. You might choose to split each expense as it comes in or keep the receipts and pay your spouse at the end of each month whatever is ?owed.? You could also take turns in paying for dinner, this also qualifies as splitting costs evenly.