Thread Rating:
  • 0 Vote(s) - 0 Average
  • 1
  • 2
  • 3
  • 4
  • 5
Excel Formula help
#1
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?
Reply
#2
why not put an 1 instead of X and do the SUM?
Reply
#3
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
Reply
#4
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.
Reply


Forum Jump:


Users browsing this thread: 1 Guest(s)