calculating averages with filters on

[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

 

[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
-------------------------------------------

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


------------------------------------------------



~~Now Available: Financial Statements.xls, a step by step guide to

creating financial statements

 

[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


------------------------------------------------

~~View and post usenet messages directly from http://www.ExcelForum.com/

~~Now Available: Financial Statements.xls, a step by step

guide to creating financial statements