Way to Average Filtered Data?

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
 

Excel Facts

Pivot Table Drill Down
Double-click any number in a pivot table to create a new report showing all detail rows that make up that number
and have it dynamic, so that every time new criteria are selected, the AVERAGE function only averages the data that are on screen?
 
Upvote 0
Hi Justin,

What you need is very easy to get via PIVOT TABLE

You can make the table DYNAMIC so when you add records you'll have only to REFRESH

Via pivot table you don't need to use formulas or filter and you can get any information instantly .

If you want -send me a sample of your data and I'll try to convince you to use PT
 
Upvote 0

Forum statistics

Threads
1,213,535
Messages
6,114,192
Members
448,554
Latest member
Gleisner2

We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.
Allow Ads at MrExcel

Which adblocker are you using?

Disable AdBlock

Follow these easy steps to disable AdBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

Disable AdBlock Plus

Follow these easy steps to disable AdBlock Plus

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back
Back
Top