Thread
:
Averaging Values in Auto Filter
View Single Post
#
2
Domenic
Posts: n/a
Use the SUBTOTAL function...
=SUBTOTAL(1,Range)
Hope this helps!
In article ,
Mr. Jan Park <Mr. Jan
wrote:
I'm using Excel 2000 to track some travel expenses. At the top of each
expense column I setup a cell that calculates the averages for the values
contained in the column using the AVERAGE function. I also have enabled auto
filter for each column. Currently, the AVERAGE function performs its
calculation for the entire range within each column, even when I select a
subset of entries using the auto filters. What I would like to do is somehow
setup my spreadsheet so the averages are calculated for whatever range I
select using the auto filters. I want the average calculations to adjust
according to the auto filters. Please let me know how I can do this.
Thank You!
Mr. Jan Park
Reply With Quote