Google Sheets Query – Remove Row from Results

google sheetsgoogle-sheets-query

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?

Best Answer

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

Related Topic