How can I max and average the results of a Filter?
If I select the range, it will consider the hidden values that do not match the filter!
You can use the SUBTOTAL function
=SUBTOTAL(1,range) returns the average of the filtered values in
range. Change 1 to 4 for the maximum, and to 5 for the minimum. See
http://office.microsoft.com/en-us/excel-help/subtotal-function-HP010062463.aspx for more info.
You can find your answer for expression(s) here
Microsoft is conducting an online survey to understand your opinion of the Msdn Web site. If you choose to participate, the online survey will be presented to you when you leave the Msdn Web site.
Would you like to participate?