calculating averages with filters on

R

robert_woodie

i have a coloumn of data which i want to calculate an average for, i ca
do this for the whole coloumn but i want it to change dependant on th
filtering applyed, im using the auto filter option.

Basically i want to calculate an average of what i can see on th
screen

Ne ideas???

Rober
 
E

Earl Kiosterud

Robert,

Use something like:

=SUBTOTAL(1,B2:B65536)

Change the cell references as appropriate.

As an aside, you may wish to put this above the autofilter. If it's a large
list, you can use Windows - Freeze panes to keep the table headings, your
subtotals, etc on the screen as the user scrolls down.

--
Earl Kiosterud
mvpearl omitthisword at verizon period net
-------------------------------------------

robert_woodie said:
i have a coloumn of data which i want to calculate an average for, i can
do this for the whole coloumn but i want it to change dependant on the
filtering applyed, im using the auto filter option.

Basically i want to calculate an average of what i can see on the
screen

Ne ideas???

Robert
Click to expand...
creating financial statements
 
J

Jason Morin

Check out the function SUBTOTAL under the Help menu.

HTH
Jason
Atlanta, GA
-----Original Message-----

i have a coloumn of data which i want to calculate an average for, i can
do this for the whole coloumn but i want it to change dependant on the
filtering applyed, im using the auto filter option.

Basically i want to calculate an average of what i can see on the
screen

Ne ideas???

Robert


------------------------------------------------
[/url]
~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step
Click to expand...
guide to creating financial statements
 
Top