Excel - Find Vertical
Today i would like to indicate SUBTOTAL function that permit you to apply any sort of formulas like:
AVERAGE, COUNT, COUNTA, SUM...
ignoring hidden rows by a filter or ignoring manually hidden rows.
About more details and examples you might refere to these two links:
