Get rid of row in result of Google Spreadsheets query

Question

I use the following formula in my Google Spreadsheet:

QUERY(Inkomster!A2:G;"SELECT SUM(C) WHERE G="&B3&" AND F='"&A3&"'")

This returns the following (On two different rows that is)

H1=sum
H2=3720

I don't want the result of the query to return two rows, I'm not interested in the first row. Just the second one. How can I accomplish that?

Your line of code is impossible to interpret without know what cells B3 and A3 are.
Can you give me some feedback on the answer I gave you? Did it work?
Sorry about that. I tried it know and it did indeed work. However i'd already solved it using query without Sum, and then encapsulate the query method with sum().

Jacob Jan Tuinstra · Accepted Answer · 2013-01-26 20:04:41Z

up vote 1 down vote accepted

You can use the following formula for that:

INDEX(QUERY(Inkomster!A2:G;"SELECT SUM(C) WHERE G="&B3&" AND F='"&A3&"'"),2,0)

The 2 references the row number and the 0 or 1 references the column number

edited Jan 26 at 20:04

answered Jan 26 at 19:58

Jacob Jan Tuinstra
3,3542839

migrated from superuser.com Jan 26 at 19:57