Try this:
=SUMPRODUCT(SUBTOTAL(109,OFFSET(C5:C30,ROW(C5:C30)-MIN(ROW(C5:C30)),0,1)),(C5:C30>0)+0)