I'm trying to make this query work on my spreadsheet on chrome Win7:
=QUERY(A1:D5;"SELECT MAX(A), COUNT(A), SUM(C) GROUP BY (A) FORMAT MAX(A) 'MMMM' ")
Everything is ok except for the format part. I'd like my date to show just as a month name but it shows exactly in the standard way (dd/MM/YYYY).
I would like to point out that neither a simple query like
=QUERY(A1:D5;"SELECT A FORMAT A 'MMMM'")
displays the dates in the wanted format =\
What am I doing wrong? The document I'm working on is this: BENZINA
=QUERY(A:E;"SELECT B, COUNT(A), SUM(D) WHERE D IS NOT NULL GROUP BY B")