Checking if a number is value or text??

Originally Posted by nflsales

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

Perfect! But, can you explain the ,"<"&..... and how do you get that "cap" between the nines? Under what circumstanses can one use this formula?

Thanks

Patish