When using the SUBTOTAL function,
I expect the function code 9 to SUM all values in a range unless they are the result of another SUBTOTAL function.
I expect the function code 109 to SUM all VISIBLE values in a range unless they are the result of another SUBTOTAL function.
However, as shown below, 9 and 109 are both including values that are hidden by a filter.
In the picture, the red is indicating the location of hidden rows and the results of the two functions. The two functions are also shown as text one column to the left of their results.