Assume that the total prize money is 1234

List the names in column A
List the matches attended in column B
In C1, enter:

=(1234*B1/SUM(B:B)) and copy down. For example:

john 10 57.40
bob 20 114.79
max 30 172.19
larry 12 68.87
moe 43 246.80
curly 98 562.47
shep 2 11.48

--
Gary''s Student - gsnu200775


"Can''t get it" wrote:

I am a pool league team captain with 5 players. The problem is that not all
of the players have showed up to play each week, but yet at the end of the
season they are wanting their equal share of the prize money awarded. I am
not going to give a player that has only been there to play 10 matches the
same amount that a couple other players that have been there to play 30
matches. I know the formula to determine the percent of matches played, but
what I need to know is how do I figure out what percent their share is?

Can someone please help???