SUMIF Function

How to SUMIF Between Two Dates in Google Sheets (3 Ways)

Efficiently tracking business performance is crucial, and one way to do this is by using the SUMIF function in Google Sheets to quickly and easily ...

How to Use Wildcard in Google Sheets (3 Practical Examples)

Wildcards are a set of special symbols that help you for an effective search result and can represent a group of similar strings at a time. In this ...

How to Ignore Blank Cells with AVERAGE Formula in Google Sheets

We average our data often in Google Sheets. However, when we average our data, we may find blank cells. While averaging our data, we may want to omit ...

[Fixed!] Wildcard Is Not Working in Google Sheets (5 Solutions)

In Google Sheets, we use wildcards to find data and perform different operations using functions. But sometimes problems arise that the wildcard is ...

How to Calculate Moving Average in Google Sheets (2 Ways)

In the financial analysis, we use the moving average as a tool. It is also known as the running average. We can calculate the moving average by ...

How to Sum Using ARRAYFORMULA in Google Sheets

Every cell in your specified data range is applied with a single formula via the ARRAYFORMULA function in Google Sheets. By converting your formula ...

How to Use ARRAYFORMULA in Google Sheets (6 Examples)

We use various functions in Google Sheets to make our data look meaningful. Most of the time you need to copy-paste the functions or drag them to ...

How to Calculate Conditional Weighted Average in Google Sheets

We frequently use Google Sheets to average or sum any data. When we need to average a dataset that is based on a specific set of criteria, we compute ...

How to Use Wildcard with IF Condition in Google Sheets (3 Ways)

Knowing how to use Wildcard characters is a great tool to possess while working in Google Sheets. Wildcards can help you maximize your search ...

How to Use SUMIF Function with Wildcard in Google Sheets

This article covers how to use the SUMIF function with wildcard to sum cells based on criteria in Google Sheets. You may sum cells based on a variety ...

Google Sheets: Sum if Cell is Not Blank

In this tutorial, we will look at how to sum if a cell is not blank in Google Sheets over a range of cells. The Basic Way to Sum if a Cell is Not ...

How to Sum Cells from Different Sheets in Google Sheets (3 Easy Ways)

In this simple tutorial, we will look at a few ways we can use to sum cells across different sheets in Google Sheets. While the idea is simple, ...

Google Sheets: Sum If there are Multiple Conditions (3 Ways)

In this simple tutorial, we will look at a few scenarios where we sum values in Google Sheets if there are multiple conditions. The Core of the ...

Find the Sum of Cells with Specific Text in Google Sheets

In this simple tutorial, we will look at a few ways to find the sum of cells with specific text in Google Sheets. While it sounds simple, there ...

Google Sheets: Sum an Entire Column (4 Easy Ways)

Adding or summing values in a spreadsheet is a common process. And with such a versatile application like Google Sheets, we have so many ways we can ...