Use this tag for Google Sheets questions that involve the use of spreadsheet formulas.
In Google Spreadsheets, I need to use the COUNTIF function on a range with multiple criteria. So in the table …
regex google-sheets countif google-sheets-formula array-formulasI want to create a TOTAL row at the top of my spreadsheet. In this row, each cell should be …
google-sheets sum google-sheets-formulaI have an index/match formula that matches a specific file based on the date value of certain cells. Here's …
google-apps-script google-sheets google-sheets-formulaI would like to aggregate the data of multiple spreadsheets into one spreadsheet. Spreadsheet 1 has a Row of Strings A2:…
google-sheets google-sheets-formula array-formulas importrangeIn Google spreadsheets, I need a formula to extract all digits (0 to 9) contained into an arbitrary string, that might contain …
regex google-sheets extract google-sheets-formula array-formulasI have a Google Spreadsheet containing the teams of the UEFA EURO 2012, and their scores: Team Points Goals scored ------ …
filter google-sheets google-sheets-formulaI have one array 1 2 3 another array 4 5 6 How do I use one function to join the 2 arrays? 1 2 3 4 5 6
arrays google-sheets google-sheets-formula1950 minutes is 32.5 hours. How do I calculate this using a formula in Google Sheets? I am logging the number of …
google-sheets google-sheets-formulaI have a Google Spreadsheet with 3 columns that are either blank or have a value. I want to get the …
google-sheets google-sheets-formulaAnother problem with Google Spreadsheet API. I'm trying to use QUERY() function in order to get all customers from our …
google-sheets google-sheets-formula google-sheets-query