Sum Formula Not returning any values in a table

[NatetheGreat]

Hi I have two columns in a table with values in them

CumB,CumA

Formulas are
=SUM($AI$16:AK16)
=SUM($AL$16:AN16)

This gets copied down the column and gives me some rolling sums of some other columns in the table... that's fine works great. Simple general format cells summing to a general format cell sum .

For some reason when I try to put in a formula on the column next to CumB and CumA
=SUM(Stats[[#This Row],[CumB]:[CumA]])


There is a -12 general cell format value in this row's (broken on all rows) CumA and a 0 in CumB.



=Stats[[#This Row],[CumA]]+1 returns value -11 as expected
BUT
=Stats[[#This Row],[CumB]]+1 returns a Zero? 0+1=0? QUE !?
Even
=Stats[[#This Row],[CumBid]] when there is a 122 values in this row cumbid.... will return a zero!?

Actually anything referencing a value in the CumB column returns zero. Regardless of the function or of the value within any cell in this column.... something is not being read.

I have checked and it is indeed general, not numbers masquerading I text cells. I don't know what else to check. Driving me crazy!!!!


I thought maybe its something to do with the underlying Sum's opulating the values in the CumB and CumA columns formulae, however that is all values in general format cells.


STUMPED !!