google sheets countif - Free Excel Tutorial

Rank Numbers without Repetitive Ranks in google sheets

This article will guide you how to rank numbers in a range with unique ranking in google sheets. How to use the Rank function in google sheets to get a unique ranking for ranges with duplicate values. Ranking without Repetitive Ranks Suppose you try to use the RANK function to rank values in a range… read more »

Rank Numeric Values with Duplicate in Google Sheets

Suppose you have an urgent task of ranking a list with duplicate values, what would be the first approach you would think of? Is there a quick and easy way to do this task in Google Sheets? This article will talk about how to rank a given list that contains duplicate values by using the… read more »

Google Sheets COUNTIF Function

This article will introduce you how to use the COUNTIF function in google sheets, and will show you a good example to better understand the usage of the COUNTIF function. Google Sheets COUNTIF Function Description The google sheets COUNTIF function is used to count the number of cells in a cell range that meet a… read more »

Count Attendance and Absence with Google Sheets COUNTIF

In our campus life and work life, we usually record everyone’s attendance. Today we will introduce you the application of Google Sheets COUNTIF function to count the attendance. Using a week as an example, we use the following example to show you how to use Google Sheets COUNTIF function to count attendance. As shown above,… read more »

Google Sheets COUNT Function

This post will guide you how to use Google Sheets COUNT function with syntax and examples in Google Spreadsheets. Description The Google Sheets COUNT function counts the number of cells that contain numbers, and counts numbers within the list of arguments. It returns a numeric value that indicate the number of cells that contain numbers… read more »

sort dates in chronological order in google sheets

Assume you have a date list that has different date formats, as seen in the accompanying picture. In this instance, google sheets’s Sort function will fail to sort them appropriately. However, you may convert all various date formats to a particular format, such as mm/dd/yyy, and then arrange them chronologically. This post will demonstrate how… read more »

Google Sheets IF Function

This post will guide you how to use Google Sheets IF function with syntax and examples in Google Spreadsheets. Description The Google Sheets IF function perform a logical test to return one value if the condition is TRUE and return another value if the condition is FALSE. The IF function is a build-in function in… read more »

Check If a Cell is Blank or Empty in Google Sheets

The article demonstrates how to check if a range of cells is blank or empty by ISBLANK and other functions to recognize empty cells in Google Spreadsheets and take appropriate action based on their status. There are several circumstances in which you need to determine if a cell is empty or not. If a cell… read more »

Sidebar