I have the following Averageif function



=AVERAGEIF($M$2:$M$1000,M1005,$L$2:$L$1000)

I would like to filter my table and when I do so, I want the averageif function to only count the visible rows.

Please help
Thanks

Perhaps http://www.mrexcel.com/forum/excel-q...dden-rows.html

__________________
Using O365 v2503 - Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post