=SUBTOTAL(9,G7:G500)