Microsoft Office Forums - View Single Post - [Solved] AVERAGEIF function excluding hidden rows

Thread: [Solved] AVERAGEIF function excluding hidden rows

View Single Post

Old

05-17-2015, 11:05 AM

michael_1962 michael_1962 is offline

michael_1962 is offline

michael_1962 uses Windows 7 64bit

Windows 7 64bit michael_1962 uses Office 2007

michael_1962 uses Office 2007

Office 2007

Novice

The original poster

Join Date: May 2015

Posts: 2

michael_1962 is on a distinguished road

Default

AVERAGEIF function excluding hidden rows

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

Reply With Quote