Since you guys have been very helpful before, I thought I'd ask if you could
help me do a SUMIF (or other) solution to the following

Col "A": player name
COl "B": team name
Col "D": attempts

about 300 rows of data, not ordered by team.

What I want in Col "L" is the %age of attempts the player has had on his
team, the players will be mixed up, not in team order, so I want to be able
to see immediately without sorting that a player has had 34.5% of the
attempts on the team he plays for

Can this be easily done?

cheers !
Lee