Why is the formula not working in Google Sheets?

I

Illarion Labahua2017-09-17 00:47:34

Google Sheets

Illarion Labahua, 2017-09-17 00:47:34

Why doesn't this formula work:
=QUERY(MyStock!T3:AB99;
"SELECT T, AVG(V), W, SUM(X), SUM(Y), SUM(Z), SUM(AA), SUM(AB)
GROUP BY T, W
LABEL T 'Name', AVG(V) 'Bought', W 'For sale', SUM(X) 'Road', SUM(Y) 'Sochi', SUM(Z) 'City', SUM( AA) 'House', SUM(AB) 'Nino'";1)
Located at:
https://docs.google.com/spreadsheets/d/1Y0Se2V_oTf...
Cell J3. SQL and function Query I know.

Reply

Answer the question

In order to leave comments, you need to log in

1 answer(s)

I

Imran Guseynov, 2017-12-11
@imran_stxa

File > Publish to Web > select the desired sheet.
Otherwise, the whole table is available