AVERAGEIF function excluding hidden rows

		Microsoft Office Forums > Microsoft Excel > Excel
AVERAGEIF function excluding hidden rows

FAQ

Mark Forums Read

Thread Tools

Display Modes

05-17-2015, 11:05 AM

michael_1962 michael_1962 is offline

Windows 7 64bit AVERAGEIF function excluding hidden rows

Office 2007

Novice

Join Date: May 2015

Posts: 2

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

« Previous Thread | Next Thread »

Thread Tools
Show Printable Version Email this Page
Display Modes
Switch to Linear Mode Switch to Hybrid Mode Threaded Mode

Similar Threads
Thread	Thread Starter	Forum	Replies	Last Post
MODE function excluding hidden rows	michael_1962	Excel	1	05-21-2015 10:09 PM
VBA to keep hidden rows hidden when filtering	tectonicseer	Excel Programming	1	07-27-2014 11:54 AM
a function that deletes all rows with no value in a certain column?	dunndealpr	Excel	2	06-08-2013 06:50 AM
how to view hidden rows	gsrikanth	Excel	10	01-27-2012 05:29 AM
hidden rows	gsrikanth	Excel	5	01-19-2012 02:40 PM

Other Forums: Access Forums

All times are GMT -7. The time now is 03:18 PM.