Does any menu come up when you hover over the Total. If it is Automatic, Change to Sum from Dropdown.
I tried actually, but the options are all greyed and I can only choose automatic.
I suspect you use table calculations.
Under table calculations, g.total logic is very different.
Anyways, without seeing your data(packaged workbook), nothing it's difficult to say anything.