Top "Google-sheets-formula" questions

Use this tag for Google Sheets questions that involve the use of spreadsheet formulas.

How do I combine COUNTIF with OR

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-formulas
Sum of row n through last row

I want to create a TOTAL row at the top of my spreadsheet. In this row, each cell should be …

google-sheets sum google-sheets-formula
Force google sheet formula to recalculate

I 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-formula
Combining multiple spreadsheets in one using IMPORTRANGE

I 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 importrange
Extract digits from string - Google spreadsheet

In 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-formulas
Filter a range by array

I have a Google Spreadsheet containing the teams of the UEFA EURO 2012, and their scores: Team Points Goals scored ------ …

filter google-sheets google-sheets-formula
google spreadsheet: join arrays using function NOT CODE

I 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-formula
How to convert a number into hours in Google Sheets

1950 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-formula
Google Spreadsheet multiple column filter using OR

I have a Google Spreadsheet with 3 columns that are either blank or have a value. I want to get the …

google-sheets google-sheets-formula
Google spreadsheet Query Error - column doesn't exist

Another 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