OLineCoach
Board Regular
- Joined
- Feb 27, 2005
- Messages
- 126
I have a workbook that tracks each play of a football game. It has a worksheet for Offense as well as Final Stats. Am trying to figure a way to compute individual player stats using IF and COUNTIF.
Example:
On Worksheet2 (Offense) there is a cell for Player Number, Run Yards, Receive Yards, etc.
On Worksheet1 (Individ Stats) I would like to be able to enter the number of the player in cell A3 and in cell B3 get the number of rushing attempts. I would do this using the CountIf function.
My problem now is computing the number of yards the player rushed for according to the number from Cell B3. I was trying to use:
=If(Offense!F6:F169 "=22", SUM(G6:G169))
where Column F in Offense is Player Number, and Column G is Rushing Yards.
WILL WELCOME ANY SUGGESTIONS/HELP....THX in Advance
Example:
On Worksheet2 (Offense) there is a cell for Player Number, Run Yards, Receive Yards, etc.
On Worksheet1 (Individ Stats) I would like to be able to enter the number of the player in cell A3 and in cell B3 get the number of rushing attempts. I would do this using the CountIf function.
My problem now is computing the number of yards the player rushed for according to the number from Cell B3. I was trying to use:
=If(Offense!F6:F169 "=22", SUM(G6:G169))
where Column F in Offense is Player Number, and Column G is Rushing Yards.
WILL WELCOME ANY SUGGESTIONS/HELP....THX in Advance