Sheetgo Blog
Your go-to resource for all things spreadsheet related
The ADDRESS Google Sheets function returns a cell’s address in the form of a text. It is noteworthy that the resulting address is a string...
This Google Sheets SWITCH evaluates an expression against a set of specific cases. The first case to evaluate as TRUE will return a...
The OFFSET function in Google Sheets references a range of cells that are shifted or displaced from a starting reference cell. You specify...
The SUMPRODUCT function in Google Sheets multiplies corresponding items within arrays of equal size and returns the sum of the results....
The Google Sheets TODAY function returns the current date and time, based on the user’s computer settings. It’s a dynamic or “volatile”...
Instead of displaying ugly error messages, IFERROR enables you to clean up your spreadsheet and replace errors with other values. This...
The IF function in Google Sheets enables logical decision making with a simple if-else structure. It checks whether a condition in a cell...
The Google Sheets SEARCH function returns the position of a substring within a text. It is the right tool if you need to find a specific...
The DCOUNTA formula in Google Sheets counts the number of values in a table-like array or range that meet specific criteria. It is similar...
As the name suggests, the Google Sheets UNIQUE function enables you to pull out unique rows from a range, discarding any data that’s...
In Google Sheets, the MATCH function gives you the relative position of an item within a range of cells. Basically, if you want to know...
When you’re carrying out data analysis, statistical measures help you to understand underlying trends. One of the most common...
English 
Español 
Português do Brasil 
Français