![]() |
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. |