Operations in Google Sheets
Google Sheets
How to Count Unique Values in Google Sheets (With Examples)
Often you may want to count the number of unique values in Google Sheets.
Fortunately this is easy to do using the COUNTUNIQUE() function.
The following...
Google Sheets
How to Calculate Compound Interest in Google Sheets (3 Examples)
We can use the following compound interest formula to find the ending value of some investment after a certain amount of time:
A = P(1...
Google Sheets
How to Select a Random Sample in Google Sheets
Often you may want to select a random sample from a dataset in Google Sheets. Fortunately this is easy to do using the RAND()...
Google Sheets
How to Combine Columns in Google Sheets (With Examples)
You can use one of the following methods to combine multiple columns into one column in Google Sheets:
Method 1: Combine Columns with & Operator
=A1&B1
Method...
Google Sheets
How to Count Number of Occurrences in Google Sheets
You can use the =UNIQUE() and =COUNTIF() functions to count the number of occurrences of different values in a column in Google Sheets.
The following...
Google Sheets
Google Sheets: How to Sum Across Multiple Sheets
You can use the following basic syntax to sum values across multiple sheets in Google Sheets:
=SUM(Sheet1!A1, Sheet2!B5, Sheet3!A12, ...)
The following example shows how to...
Google Sheets
Google Sheets: How to Use COUNTIF From Another Sheet
You can use the following basic syntax to use a COUNTIF from another sheet in Google Sheets:
=COUNTIF(Sheet1!A1:B20, ">10")
The following examples show how to use this...
Subscribe
- Never miss a story with notifications
- Gain full access to our premium content
- Browse free from up to 5 devices at once
Must read