Maybe on the Monthly sheet the numbers to be added are text values which look like numbers. See what a SUM formula directly on the Monthly sheet produces.

Hope this helps.

Pete