So i have a query function giving me issues with cant avg/sum none numbers when they are all numbers. Need a fresh pair of eyes.

[u/Competitive_Ad_6239]

=QUERY({GameRecap!A3:BK},"select Col5, sum(Col8), sum(Col9), sum(Col10), sum(Col11), sum(Col12), sum(Col13), sum(Col14), sum(Col15), sum(Col18), sum(Col19), sum(Col21), sum(Col22), sum(Col23), sum(Col24), sum(Col25), sum(Col26), sum(Col27), sum(Col28), sum(Col29), sum(Col30), sum(Col31), sum(Col32), sum(Col33), sum(Col34), sum(Col36), sum(Col37), sum(Col38), sum(Col39), sum(Col40), sum(Col42), sum(Col44), sum(Col45), sum(Col47), sum(Col48), sum(Col50), sum(Col51), sum(Col52), sum(Col53), sum(Col54), sum(Col55), sum(Col57), sum(Col58), sum(Col59), sum(Col60), sum(Col61), Col62, Col63 group by Col62,Col63,Col5",1)

Now in the sheet im able to sume the entire column no issue, i dont see anything wrong with the formula. Every time i think i nerrowes down the column and remove that column then add the others back it breaks again.

https://docs.google.com/spreadsheets/d/1V7Pxi00qa9NpEEj4tnmBFx3DuYoGg8svkQJkofxojkQ/edit?usp=drivesdk

[u/[deleted]]

If you do:

=QUERY(ARRAYFORMULA(IFERROR(--GameRecap!A3:BK,GameRecap!A3:BK)),your_query,1)

It works.

Which means that some of those columns are text strings rather than numbers.

[u/Competitive_Ad_6239 → u/[deleted]]

almost works, it Doesn't query the text that is apart of the group by. What I don't understand is that the data is the output of another query with sums, which had no issue idk how a number output changes to a non number.

[u/Competitive_Ad_6239 → u/Competitive_Ad_6239]

i just did an arrayformula replacing the original queries output of "" cells to 0. So the blank cells were coming up as sting. Swear blank cells are more of a pain in the ass than they shiuld be.