JustinWWolcott
Board Regular
- Joined
- Mar 20, 2007
- Messages
- 158
Is there any way to find the average (or sum, stdev, var, etc...) on data that's been filtered *without* using a pivot table.
I'm putting together a data collection worksheet that does some other things for a study he's doing. The study is over football players in the weight room.
In column A:A he's got the class year of the individual players.
In column B:B he's got the Position they play.
In column C:C he's got the name of the lift
In column D:D he's got how much they lifted
I'd like to have a little stats sheet that puts out quick data for what ever has been filtered.
Say that I want to know the average of The SENIOR (class year) OFFENSIVE-LINEMEN (position) on SQUATS (lift).
Is this doable?
thanks a tonne,
Justin
I'm putting together a data collection worksheet that does some other things for a study he's doing. The study is over football players in the weight room.
In column A:A he's got the class year of the individual players.
In column B:B he's got the Position they play.
In column C:C he's got the name of the lift
In column D:D he's got how much they lifted
I'd like to have a little stats sheet that puts out quick data for what ever has been filtered.
Say that I want to know the average of The SENIOR (class year) OFFENSIVE-LINEMEN (position) on SQUATS (lift).
Is this doable?
thanks a tonne,
Justin