QUERY function works in example sheet but not in a new sheet with same formula

Question

Screenshot from new sheet

screen shot from google example sheet

I get error when using the formula in a new sheet, but the same formula works in google`s example sheet.

What am i doing wrong?

It could be an issue with the Google sheet Language setting. This might guide you - [Try this](https://www.bettercloud.com/monitor/the-academy/using-formulas-in-different-languages-in-google-sheets/) — vvk24, Jul 04 '20 at 10:17

score 1 · Accepted Answer · answered Jul 04 '20 at 10:48

1

your sheets are of different locale - English / Non-English

English sheets use , while in Non-English you need to use ;

therefore:

=QUERY(A1:B5; "select B"; 1)

answered Jul 04 '20 at 10:48

player0

1

Thanks! You are right, it was of different locale :P 3 Hours wasted. Damn. (Norway btw) – Fokki yuo Jul 04 '20 at 10:54

1 Answers1