Checking if a number is value or text??

Hi Y'all

I'm having a serious issue with a simple SUM formula. See the attached file. In column Q the SUM formula in cell Q247 returns an error- #DIV/0!. The problem originates in column G where you will see in cell G247, I think it is, an error returned from the SUM formula. I tried checking whether any of the numbers in column G are values by using the ISNUMBER formula. All results return true. I have seached the internet for solutions and none are forthcoming.

It's driving me "up the wall". Can anyone help.

Thanks

Patish

Hi,

Can you check your attachment? Not sure if it's just me, but unable to open.

Regards

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