SUBTOTAL(109,$G$8:$FH$8), hiding a column does not affect the subtotal. But, hiding a row in a subtotal of a vertical range does affect the subtotal.