Average For Filtered Cells
I use the auto-filter feature.
Is there a formula I can use that will compute the average of the values in a column for just the cells that are displayed after using the auto filter ? Thank you in advance. |
Average For Filtered Cells
Look in the help index for SUBTOTAL
-- Don Guillett Microsoft MVP Excel SalesAid Software "carl" wrote in message ... I use the auto-filter feature. Is there a formula I can use that will compute the average of the values in a column for just the cells that are displayed after using the auto filter ? Thank you in advance. |
All times are GMT +1. The time now is 04:27 AM. |
Powered by vBulletin® Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
ExcelBanter.com