Forum Discussion
Converting a large spreadsheet to a table and formula results change
If you converted the range to the table and in row 3 are headers of the table, with conversion to table they were converted to the texts. In formula you shall convert them back to number with double dash or VALUE(). And better to use structured references here.
Could you upload either the actual file or a sample of it (a subsection, perhaps)? In the absence of that, anything most of us could offer would be guesses, maybe educated guesses, but guesses.
It's possible, I'd think, that one of those "not affected" columns is, in fact, affected. It's also possible, since your cell references are neither altogether relative nor altogether absolute, that something in the conversion did affect those references. But those are just hypotheses, in the absence of seeing the evidence..