As far as I know, Subtotal is the only built in excel function that ignores filtered cells.
Are there any other such functions?
I will award points for examples of other functions, or for authoritative documentation stating that Subtotal is the only such function.
Also, as far as I know, there aren't any excel functions that ignore manually hidden cells. Can anybody prove me wrong?