Formulas Archives - Page 2 of 25

How to Find 7-Day Moving Average in Google Sheets

August 3, 2023 Formulas

The Simple Moving Average (SMA) constantly adds up an agency's closing price and divides the sum by the number of periods to get the average price of ...

How to Find 7-Day Moving Average in Google Sheets

How to Make REGEXMATCH Case Insensitive in Google Sheets

August 16, 2023 Formulas

The REGEXMATCH function is a very helpful tool in Google Sheets. However, this function is case-sensitive. So, sometimes it eliminates some matches ...

How to Make REGEXMATCH Case Insensitive in Google Sheets

Use COUNTIF Function to Count Unique Values in Google Sheets

August 16, 2023 Formulas

Using the COUNTIF and UNIQUE functions in Google Sheets can greatly benefit businesses and finance professionals by quickly identifying and tracking ...

Use COUNTIF Function to Count Unique Values in Google Sheets

Google Sheets Add Calculated Field for Pivot Table with COUNTIF

August 16, 2023 Formulas

In Google Sheets, the Pivot Table can be a very useful tool to summarize a huge dataset. To analyze data, you can insert any general function from ...

Google Sheets Add Calculated Field for Pivot Table with COUNTIF

How to Insert an Exponent in Google Sheets (3 Easy Ways)

August 16, 2023 Basics

We frequently use exponents in our calculations. Sometimes we require exponents in texts also; for example, consider expressing Einstien’s ...

How to Insert an Exponent in Google Sheets (3 Easy Ways)

How to Use COUNTIF for True Condition in Google Sheets

August 16, 2023 Formulas

By using the COUNTIF function to find TRUE conditions and values in Google Sheets, a business can quickly and easily count the number of times a ...

How to Use COUNTIF for True Condition in Google Sheets

How to Use COUNTIF for Cells Not Equal to Text in Google Sheets

August 16, 2023 Formulas

In Google Sheets, if you want to count values except for any specific values, you can also apply the COUNTIF function with a specialized operator. ...

How to Use COUNTIF for Cells Not Equal to Text in Google Sheets

How to Find Slope of Trendline in Google Sheets (4 Simple Ways)

August 3, 2023 Formulas

You might be familiar with the idea of a slope and trendline if you frequently show research reports, or financial data, or need to perform ...

How to Find Slope of Trendline in Google Sheets (4 Simple Ways)

How to Find Median in Google Sheets (2 Easy Ways)

August 16, 2023 Formulas

While working on a dataset sometimes you need to get the middle value of the dataset. For example, if you are working on the sales chart of your ...

How to Find Median in Google Sheets (2 Easy Ways)

How to Split Text to Columns Using Formula in Google Sheets

August 16, 2023 Formulas

In order to properly extract meaning from the data that has been gathered, text strings must be split as a necessary first step in data analysis. For ...

How to Split Text to Columns Using Formula in Google Sheets

How to Filter Unique Values in Google Sheets (5 Simple Ways)

August 16, 2023 Formulas

Suppose you are working on a dataset where you must remove duplicates and count all the unique values. If your dataset is large then finding every ...

How to Filter Unique Values in Google Sheets (5 Simple Ways)

Use COUNTIF If Cell Contains Specific Text in Google Sheets

August 16, 2023 Formulas

In business and finance, it's essential to analyze data quickly and accurately. One way to do this is by using the COUNTIF function in Google Sheets ...