Posted 8 September 2017, 1:51 pm EST
I'm using Spread.NET for WinForm v4.0.3509.2008. Attached is a JPEG image of a portion of my spreadsheet where I'm having trouble getting some SUM formulas to work within the cells.
The two columns in focus are the Real-time Nominated and Final Variance. The Final Variance column is formula set using R1C1 style taking the Real-time Nom numbers and subtracting them from the Confirmed column. As you can see, the formula appears to be working fine. At the bottom, in between the two bold black lines, is where I am having summing issues with the Final Variance column. It continues to say 0 as the SUM result and my formula is just a simple SUM(R1C11:R342C11). I've triple-checked and that is the correct column/row range for this data. I've opened up "Allow User Formulas" to even type this in another cell, but I get the same results... can I not SUM a column of formulas? This seems unusual. Any ideas?