MacResource
Excel Formula help - Printable Version

+- MacResource (https://forums.macresource.com)
+-- Forum: My Category (https://forums.macresource.com/forumdisplay.php?fid=1)
+--- Forum: Tips and Deals (https://forums.macresource.com/forumdisplay.php?fid=3)
+--- Thread: Excel Formula help (/showthread.php?tid=119902)



Excel Formula help - Microman - 07-09-2011

Have a group of people that volunteers.

They earn money towards helping pay for hotel during a convention each year.

Each time a person volunteers I put an x next to their name for that date.

Tips and usually $50 is given to the group each time.

I divide the number of volunteers working that date into the $50 + Tips and get a small figure around $6.25 each earned.

I do this about 12-15 times during the season.

Is there a formula that I could say if there is an X in this column next to the name add the $6.25 to the total for that person.

So at the end of the 12-15 times, if a person has worked a DATE, that the "Amount each earned" for each date would be added to that persons total earned?


Re: Excel Formula help - space-time - 07-09-2011

why not put an 1 instead of X and do the SUM?


Re: Excel Formula help - cbelt3 - 07-09-2011

Space-Time has the win !
Essentially you're building a database. (Call it a list if it makes you feel better).
The data works like this:
Name Date "1" for worked
Microman 7/8/11 1
cbelt3 7/8/11 1
space-time 7/8/11 1
Microman 8/8/11 1
space-time 8/8/11 1



There is another database of 'events' that looks like this
Date Fee Tips
7/8/11 50 25
8/8/11 50 30

Use a 'pivot table' on the worker table, and display
Date #workers
7/8/11 3
8/8/11 2

Then cross-reference that to the events, and you get this:
Date Workers Earned Credit Per Worker
7/8/11 3 75 25
8/8/11 2 80 40


Re: Excel Formula help - Microman - 07-10-2011

Ok I have the 1 in a column on the date. I have the total earned, and what each person earned.

But how do I keep a running total, of the 12 or 15 events during the year, without having to manually do some adding.

One person may have 7 out of the 15 with 1 in the date column, and I need a way of adding the MONEY EACH earned add up for EACH person.

I could make another column that could represent the # and add that up the same for each person, but would be nice to learn a new feature if available. ANd if I add another column, it may make the Spreadsheet more than the one page it is now.