Checking if a number is value or text??

[Patish]

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