# How to Count Cells with Specific Value in Excel, with Case Sensitivity

If you work with data in Excel, you may need to count the number of cells that contain a specific value. However, what if you want to count only those cells that match a specific value and are case-sensitive? In this article, we will guide you on how to count cells that contain a specific value in Excel while considering case sensitivity.

## Problem

Excel provides a built-in function called COUNTIF that allows you to count the number of cells in a range that meet a specific condition. However, by default, the COUNTIF function is not case-sensitive. This means that if you want to count only those cells that match a specific value and are case-sensitive, you need to use a different approach.

## Example

Suppose you have a dataset containing the names of employees and their respective departments. You want to count the number of employees who work in the “IT” department, but you only want to count those cells that match the department name exactly, including the case sensitivity.

If you use the COUNTIF function with the argument “IT”, it will count all the cells that contain “IT” regardless of the case. This means that if there is a cell that contains “it” or “It”, it will also be counted. To count only those cells that match the exact department name, you need to use a case-sensitive formula.

## Solution

To count cells that contain a specific value in Excel, while also considering case sensitivity, you can use a combination of the SUM and IF functions. Here is the step-by-step guide:

### Step 1: Select the range of cells

First, select the range of cells that you want to count. In our example, we will select the range that contains the department names.

### Step 2: Use the IF function to test for the condition

Next, you need to use the IF function to test whether each cell in the range meets the condition. In our example, the condition is whether the cell matches the department name exactly, including the case sensitivity. The formula would be:

``=IF(A2="IT",1,0)``

This formula tests whether the value in cell A2 matches the department name “IT”. If it does, it returns 1; otherwise, it returns 0.

### Step 3: Use the SUM function to add up the results

Finally, you can use the SUM function to add up the results of the IF function. The formula would be:

``=SUM(IF(A2:A10="IT",1,0))``

This formula adds up the results of the IF function for each cell in the range A2:A10. If the cell matches the department name “IT”, it returns 1; otherwise, it returns 0.

## 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 evolving technology. On this blog, you can also explore Powerful Knowledge, Tips & Resources On Blogging, SEO and Passive income Opportunities.