Why does the =SUM() function not work with numbers transmitted by query in Google Sheet

CodePudding user response：

Change the 1 at the end of your querys to a 0.

However, the way you've written those formulas is not a very efficient way to get the values you want and may slow down your sheet quite a bit if used at scale.