Google Sheets – Solving Problems with the QUERY Function

google sheets

I tried this formula:

=concatenate(query('Scheda Intervento'!C2:K14;"select SUM (K) where (F>= date '2013-01-01' and F <= date '2013-01-31' and C = '" & A2 &"')";0))

The result is right but it gives me:

sum
35 €

but I want to have

35 €

Best Answer

Use the following formula:

=INDEX(query('Scheda Intervento'!C2:K13;"select sum (K) where (F >= date '2013-01-01' and F <= date '2013-01-31' and C = '" & A2 &"')");2;1)

After that you can perform the CONCAT handling.

Related Solutions

Google-sheets – How to do a date formula in Google Spreadsheets

Try this

=INDEX(query('Scheda Intervento'!C3:K14;"select sum (K) where (F >= date '"&YEAR(NOW())&"-01-01' and F <= date '"&YEAR(NOW())&"-01-31' and C = '" & A3 &"')");2;1)

I used the function YEAR(NOW())

Google-sheets – IMPORTRANGE formula query to query data in another file

Yes, it is possible with a construct like so:

=IMPORTRANGE("key";"Foglio1!A2:B2")

and, in New Google sheets, allow permission for the linking. key above is the spreadsheet key (long upper/lower case alphanumeric between forward slashes visible in the URL for the source sheet). Though you can use the entire URL.

Best Answer

Related Solutions

Google-sheets – How to do a date formula in Google Spreadsheets

Google-sheets – IMPORTRANGE formula query to query data in another file

Related Topic