If I am tracking the problem---- try inserting a new row in the total tab, and just under the probable problem row..................then do the insert routine for the totals from the monthly tab.

You should get the same numbers in the new row as in the old row.

That should tell you whether or not you have a formula problem for transferring data from the monthly tab......which is what I bet it is.

Obviously, then, when you find the error.......just delete that "new test row".