Take the 2-minute tour ×
Web Applications Stack Exchange is a question and answer site for power users of web applications. It's 100% free, no registration required.

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 €

share|improve this question
    
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

2 Answers 2

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.

share|improve this answer

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)
share|improve this answer

Your Answer

 
discard

By posting your answer, you agree to the privacy policy and terms of service.

Not the answer you're looking for? Browse other questions tagged or ask your own question.