=SUMIF(Q2:Q246,"<"&9^9,Q2:Q246)
try this formula in Q 247