Query malfunction in google sheets-CodePudding

I am not sure how to describe it. I will call it "Query malfunction" for now. If someone knows this, please edit my description.

I was quite happy with query function, but it seems it doesn't work on this one. I used the same formula for STORE1 and STORE2 except the sheet name. But only with STORE2 it is working normally.

Please check the picture and the sample(

CodePudding user response：

Query doesn't work properly when a column has a mix of text and numeric values. To solve your problem, try

=QUERY(arrayformula(to_text(STORE1!C2:F)),"select Col1, sum(Col4) where Col4 is not null group by Col1")

CodePudding user response：

We can't see the complete formula, but try adding a zero as the third parameter.

=QUERY(STORE1!C2:F, "your_select_clause_here", **0**)

and see if that helps?