This is probably not the most logical fix, but I selected the numbers I would be trying to add/sum, hard-code those numbers (copy, paste as values), and then Ctrl+Z - the sum function would fix itself this way.