This tutorial is about the Query function that is available in Google Spreadsheet. Query function allows users to perform a query over an array of values and is based on the Google Visualization API Query Language.
Let us try to understand the usage with a simple example that we had used for explaining Filter function in Google Spreadsheet. The objective is to retrieve the values from Result which is greater than 22500 and Type is greater than 6
The Query for retrieving the required result is
=QUERY(B1:C21,”select B where B > 22500 and C > 6″)
Where B1:C21 is the data source for the query and B > 22500 and C > 6 are the two conditions. The query gets you the expected result as shown below.