When you're working with TABULAR data, you can use the SUBTOTAL function to get variety of subtotals - such as AVERAGE, COUNT, MAX, MIN, and STDEV. 

ONE of the highlights of SUBTOTAL function is that it allows you to ignore hidden/filtered cells. So if you have a huge data SET and you filter it based on criteria or hide some rows, SUBTOTAL function will automatically update to give you the result from the visible cells only. 

Of course, if you don't WANT the data of filtered/hidden cells to be IGNORED, you can do that too.

When you're working with tabular data, you can use the SUBTOTAL function to get variety of subtotals - such as AVERAGE, COUNT, MAX, MIN, and STDEV. 

One of the highlights of SUBTOTAL function is that it allows you to ignore hidden/filtered cells. So if you have a huge data set and you filter it based on criteria or hide some rows, SUBTOTAL function will automatically update to give you the result from the visible cells only. 

Of course, if you don't want the data of filtered/hidden cells to be ignored, you can do that too.