Right, what I'm attempting to do here is work out the cost incurred to each individual of a number of people who went on a trip.
Basically, I paid for everything and now want to split the cost between appropriate people so I made a table (food down the side and people along the top).
The problem is some people didn't use all the items, and don't want to pay for the items they didn't use.
So the cost for each item needs to be divided by the number of people that say 'yes' in that table I've laid out for them.
When this column was created, I called it "Divided Amount", so now each individual item has its per-person cost in that column and it fluctuates depending on how many people respond with 'yes'.
SO the bit im struggling with: When person x has replied 'yes' for food y, I need to include item y's 'Divided Amount' in the totals table, which tells each person how much they need to pay. This needs to sum the costs of all the items that the person has responded to with a yes.
I'm sure excel can do this, access may be more appropriate - let me know what you think!
NB: While using 2010 myself, most users will be accessing via 2003 and so the file has to be saved as a .xls!
Cheers
Archea
Basically, I paid for everything and now want to split the cost between appropriate people so I made a table (food down the side and people along the top).
The problem is some people didn't use all the items, and don't want to pay for the items they didn't use.
So the cost for each item needs to be divided by the number of people that say 'yes' in that table I've laid out for them.
When this column was created, I called it "Divided Amount", so now each individual item has its per-person cost in that column and it fluctuates depending on how many people respond with 'yes'.
SO the bit im struggling with: When person x has replied 'yes' for food y, I need to include item y's 'Divided Amount' in the totals table, which tells each person how much they need to pay. This needs to sum the costs of all the items that the person has responded to with a yes.
I'm sure excel can do this, access may be more appropriate - let me know what you think!
NB: While using 2010 myself, most users will be accessing via 2003 and so the file has to be saved as a .xls!
Cheers
Archea
