# Counting Cells that Contain Values Between Two Specified Numbers in Excel

If you have a large dataset in Excel and need to determine how many cells contain values between two specified numbers, you don’t have to manually count them one by one. Excel provides a convenient function called COUNTIF that allows you to count cells that meet certain criteria, including values between two specified numbers. In this article, we will show you how to use this function step-by-step.

## Understanding the COUNTIF Function

The COUNTIF function in Excel allows you to count the number of cells in a range that meet a certain criterion. The syntax of the COUNTIF function is as follows:

``=COUNTIF(range, criteria)``

Where “range” is the range of cells you want to count and “criteria” is the condition or criterion that the cells must meet. The criterion can be a number, text, date, or logical expression. For our purpose, we will use a logical expression to count cells that contain values between two specified numbers.

## Using the COUNTIF Function to Count Cells Between Two Numbers

To count cells that contain values between two specified numbers, we will use a combination of the COUNTIF and logical operators. Here are the steps:

• Select the cell where you want to display the result.
• Type the following formula:
``=COUNTIF(range,">=value1")-COUNTIF(range,">value2")``

Where “range” is the range of cells you want to count, “value1” is the lower bound of the range, and “value2” is the upper bound of the range.

• Press Enter to calculate the result.

For example, suppose you have a dataset in cells A1:A10, and you want to count the number of cells that contain values between 5 and 10. Here’s how you can do it:

• Select cell B1.
• Type the following formula:
``=COUNTIF(A1:A10,">=5")-COUNTIF(A1:A10,">10")``
• Press Enter to calculate the result.

The result should be the number of cells that contain values between 5 and 10.

I hope you have got the solution. Thank you.

## Bibek Sapkota

I'm Bibek | Tech Enthusiast & Lifelong Learner. | Playing on the Web for the Past Few Years as an SEO Specialist and Full-Time Blogger. I'm constantly seeking out new opportunities to learn and grow, and I love sharing my knowledge with others. This is where I started this blog! Here, you will find me sharing comprehensive reviews, helpful guides, tips-tricks and ways to get the full benefits of ever-changing technology. On this blog, you can also explore Powerful Knowledge, Tips & Resources On Blogging, SEO and Passive income Opportunities.