I had a case of SUM() failing on formula cells that outputted a number, but using IMSUM() (for adding complex numbers) worked instead.

Not sure how consistently it would work, but might be easier than using NUMBERVALUE() on every cell like other suggestions. Bizarre.