# Sum Formula Not returning any values in a table

#### NatetheGreat

##### Active Member
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 !!

### Excel Facts

How can you turn a range sideways?
Copy the range. Select a blank cell. Right-click, Paste Special, then choose Transpose.

Replies
14
Views
254
Replies
3
Views
150
Replies
7
Views
418
Replies
4
Views
326
Replies
4
Views
310

1,202,962
Messages
6,052,815
Members
444,602
Latest member
Cookaa

### We've detected that you are using an adblocker.

We have a great community of people providing Excel help here, but the hosting costs are enormous. You can help keep this site running by allowing ads on MrExcel.com.

### Which adblocker are you using?

1)Click on the icon in the browser’s toolbar.
2)Click on the icon in the browser’s toolbar.
2)Click on the "Pause on this site" option.
Go back

1)Click on the icon in the browser’s toolbar.
2)Click on the toggle to disable it for "mrexcel.com".
Go back

### Disable uBlock Origin

Follow these easy steps to disable uBlock Origin

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back

### Disable uBlock

Follow these easy steps to disable uBlock

1)Click on the icon in the browser’s toolbar.
2)Click on the "Power" button.
3)Click on the "Refresh" button.
Go back