• Quote:

  The SUBTOTAL function is designed for columns of data, or vertical ranges. It is not designed for rows of data, or horizontal ranges. For example, when you subtotal a horizontal range using a function_num of 101 or greater, such as SUBTOTAL(109,B2:G2), hiding a column does not affect the subtotal. But, hiding a row in a subtotal of a vertical range does affect the subtotal.

This is what MS has to say about it in it's description of the function.
So, again, no new bug discovered

__________________
Did you know you can thank someone who helped you? Click on the tiny scale in the right upper hand corner of your helper's post