Search for data in a sheet with QUERY

Finding specific content in large spreadsheets can be tricky. Filter, sort, sum, and verify values in your data with the QUERY function in Google Sheets.

Use the QUERY function

In Sheets, open a spreadsheet. In an empty cell, type =QUERY. In parenthesis, add the following specifications separated by a comma: Cell range, separated by a colon, to perform the query on. Specific query to perform (using Google Visualization API Query Language). (Optional) Type a digit for the number of header rows at the top of the data. Press Enter. For more information and examples, see QUERY in the Google Docs editors Help Center.