Try =SUBTOTAL(101,B4:B33)