Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
conditional fraction - sumif?
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 |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Conditional SUMIF??? | Excel Worksheet Functions | |||
copy the conditional sum (SUMIF) formula | Excel Worksheet Functions | |||
adding summed cells in a conditional sumif | Excel Worksheet Functions | |||
HOW DO I COPY A CONDITIONAL SUM (sumif) AND EDIT IT? (THE SUM NEV. | Excel Worksheet Functions | |||
Conditional Format With SUMIF | Excel Worksheet Functions |