Problem QUERY function in Google Spreadsheets formula

Question

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 €

Use INDEX to capture only the second row/result: INDEX(Your formula),2,1)
i tried..it gives me the same error "sum 35€" how can i hide "sum"??
Try this: INDEX(query('Scheda Intervento'!C2:K14;"select SUM (K) where (F>= date '2013-01-01' and F <= date '2013-01-31' and C = '" & A2 &"')"),2,1)
docs.google.com/spreadsheet/… the formula is in "riepilogo totale ore date compensi operatore sheet column "C2"

Jacob Jan Tuinstra · Accepted Answer · 2013-04-22 13:39:44Z

up vote 0 down vote accepted

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.

answered Apr 22 at 13:39

Jacob Jan Tuinstra
2,8301735

1 Answer