ExcelBanter - averaging with a filter

ExcelBanter (https://www.excelbanter.com/)

- Excel Discussion (Misc queries) (https://www.excelbanter.com/excel-discussion-misc-queries/)

- - averaging with a filter (https://www.excelbanter.com/excel-discussion-misc-queries/189385-averaging-filter.html)

AAS

averaging with a filter

i would like my average of a group of numbers to change when I filter the
numbers in other columns.
thanks alot

Peter

averaging with a filter

Hi

Hope this helps:

In cell where you have the Average formula - change it to =subtotal(1,(Range)

This should change as and when you change the filter etc

"AAS" wrote:

i would like my average of a group of numbers to change when I filter the
numbers in other columns.
thanks alot

All times are GMT +1. The time now is 05:52 PM.