07-09-2011, 04:55 PM
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?
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?