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
 

Some videos you may like

Excel Facts

Back into an answer in Excel
Use Data, What-If Analysis, Goal Seek to find the correct input cell value to reach a desired result

mikerickson

MrExcel MVP
Joined
Jan 15, 2007
Messages
23,910
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?
 

rconverse

Well-known Member
Joined
Nov 29, 2007
Messages
1,187
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
 

Stfnah

New Member
Joined
Mar 12, 2010
Messages
4
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
 

rconverse

Well-known Member
Joined
Nov 29, 2007
Messages
1,187

ADVERTISEMENT

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:

Stfnah

New Member
Joined
Mar 12, 2010
Messages
4
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
 

Watch MrExcel Video

Forum statistics

Threads
1,122,708
Messages
5,597,688
Members
414,164
Latest member
ARTW

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
Top