Kitty help!

Stfnah

New Member
Joined
Mar 12, 2010
Messages
4
Hello,

Living in a house with 7 people has many perks, but working out a completely fair kitty system is not one of them.

We all cook for each other about once a week.
We note down who paid for the food, how much it cost and who was present out of the 7 people living here.

We have all tried to figure out an excel spreadsheet to work out how much money people owe/are owed at the end of each month but we havn't got the excel skills to make it work.

Could someone tell me how to make a spreadsheet work so that all I need to input is - WHO COOKED - HOW MUCH IT COSTED - WHO WAS PRESENT providing the output - WHO IS OWED WHAT AT THE END OF THE MONTH.

an example of a scruffy and incomplete kitty cooking sheet to give you an idea.. http://i121.photobucket.com/albums/o219/stefner100/dissscan017.jpg

Any help appreciated!

Many thanks , Stef
 

Excel Facts

What is the shortcut key for Format Selection?
Ctrl+1 (the number one) will open the Format dialog for whatever is selected.
I'm guessing the goal is "at the end of the month who owes money to whom?"

Who paid for the cost of a meal? The cook?

Am I correct that only those present are expected to pay for the cost of that meal?

Is the cook supposed to pay for their share of the cost or is that "paid" for by their labor of cooking?

Is there a communal money pot, into which those who owe can pay and out of which those who are owed can get reimbursed?
 
Upvote 0
Something like this should get you started. It's a lot simpler than you think! Welcome to the board.

Excel Workbook
ABCDEFGH
1DayChefPerson1Person2Person3Person4Total CostCost Per Person
2MondayPerson1XXX51.67
3Tuesday 
4WednesdayPerson2XXX103.33
5Thursday 
6FridayPerson3XXX113.67
7Saturday 
8SundayPerson4XX147.00
Sheet1





HTH,
Roger
 
Upvote 0
Fantastic!
Such a quick response, thank you.

I have just placed the formula into the spread sheet and now I have the conditional 'cost per head' values which is very helpful.

There's still a lot I need to work out though. Ill keep trying ..

@Mike -

I'm guessing the goal is "at the end of the month who owes money to whom?"
- yes, this is the goal

Who paid for the cost of a meal? The cook?
- the cook always pays for the meal

Am I correct that only those present are expected to pay for the cost of that meal?
- yes, only those present are asked to pay towards the meal. (as quite often people are away for a week or more )

Is the cook supposed to pay for their share of the cost or is that "paid" for by their labor of cooking?
- the cook pays for their equal cost of the meal. they do not get paid for cooking.

Is there a communal money pot, into which those who owe can pay and out of which those who are owed can get reimbursed?
- no, there is no communal pot. we all pay with our own money and use this system (table) to work out after a month (or two) who owes whom what.

Many thanks, Stef
 
Upvote 0
You can just add a sumif formula at the end of the month.

Excel Workbook
ABCDEFGHI
23DayChefPerson1Person2Person3Person4Person5Total CostCost Per Person
24MondayToddxxxx51.25
25Tuesday 
26WednesdayStefxxx82.67
27Thursday 
28FridayErrinxxx124.00
29Saturday 
30SundayRyanxx147.00
31MondayToddxx105.00
32Tuesday 
33WednesdayStefxxxxx81.60
34Thursday 
35FridayErrinxxx134.33
36Saturday 
37SundayRyanxxx113.67
3813.8526.857.9313.5218.85
3000



HTH,
Roger
 
Last edited:
Upvote 0
The SUMIF and $x$x:$x pieces were what I needed.

(I had just finished creating a table simply using a IF for every single box before you replied! but this coding makes the table much more flexible)

If I can upload it to googledocs I will show you what I have come up with at some point.

Again thank you so much!
Working it out by hand caused many head aches in our house so I assure you this table will go to good use!

Stef
 
Upvote 0

Forum statistics

Threads
1,213,527
Messages
6,114,144
Members
448,552
Latest member
WORKINGWITHNOLEADER

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top