How to fix encountered ""where" error in a QUERY?

Question

Google Sheets

When creating a query in a table, an error occurs, what is indicated incorrectly in it?

=QUERY('Remainders'!A:C;"select sum(C) label sum(C)' ' where(B="&I18&")")

Answer 1

Try

=QUERY('Остатки'!A:C,"select sum(C) where B='"&I18&"' label sum(C)''")

If you write label sum(C)' '(with a space), then the title will be empty and the result will be displayed on the second line below the formula.
Please note that the QUERY formula is sensitive to data types, so if you have Bstrings, then you need to write B='"&I18&"', but if these are numbers, then B="&I18&".