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)` – Jacob Jan Tuinstra Apr 22 '13 at 12:59
i tried..it gives me the same error "sum 35€" how can i hide "sum"?? – jack1986 Apr 22 '13 at 13:16
Please share the doc with us. – Jacob Jan Tuinstra Apr 22 '13 at 13:25
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)` – Jacob Jan Tuinstra Apr 22 '13 at 13:27
docs.google.com/spreadsheet/… the formula is in "riepilogo totale ore date compensi operatore sheet column "C2" – jack1986 Apr 22 '13 at 13:30

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.

-

You are looking for a label. This is the format:

`LABEL A 'MyLabel'` in this case you just need to eliminate the actual SUM label so you have to set it empty like:

``````LABEL SUM (A) ''
``````

Just put it like this:

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