In this tutorial, you will learn how to count rows with value in Excel.
To count the number of cells that match a requirement, such as the number of times a specific city occurs in a client list, use COUNTIF, one of the statistical functions.
Once ready, we’ll get started by utilizing real-world examples to show you how to count rows with value in Excel.
Table of Contents
Anatomy of COUNTIF Functions
COUNTIF Function
=COUNTIF(range, criteria)
To count the number of cells that match a requirement, such as the number of times a specific city occurs in a client list, use COUNTIF, one of the statistical functions.
Count Rows with Value in Excel
Before we begin we will need a group of data to be used to count rows with value in Excel.
Step 1
First, you need to have a clean and tidy group of data to work with.
Step 2
In this example, we want to know the number of students attending our class. To do so, we can simply count rows with value in a formula like this =COUNTIF(B2:B6,”YES”).
Step 3
Once you press Enter, your formula will return the number of students attending class.
