There is something peculiar about the spreadsheet named in this file as "Original". The way the cells are formatted or populated seem to prevent any formulas from working correctly.
I noticed, however, that if I populate the empty cells (being addressed in the formula) with zero then formulas work.
The Tab named "Original" is the bad file that I get from my supplier. The other tab named "New COLS…" is the file I manually and painstakenly repaired and entered SUM formulas in COL AG-AK.
I get very large files of this type from a supplier on a regular basis so I really need an immediate solution. Perhaps I can run a macro that will populate all the empty cells in a selected area with "0"? Thanks for your help with this, Experts!