Thread:Talk:Semantic Result Formats/format=sum disagrees with adding up basic format/reply

A #ask query is by default set to a limit of 50 (Help:$smwgQDefaultLimit).

Your table query on the other hand sets a specific limit hence the discrepancy and I'd suggest you adapt your sum query to the same limitation.