# How to Count the Number of Cells in Excel that Match One of Two Given Values

When working with large amounts of data, it can be challenging to find specific information quickly. For example, suppose you have a table of sales data for multiple products and you want to know how many sales were made for two specific products. Manually counting each cell that matches the given values is time-consuming and prone to errors, especially if the data set is large. This is where Excel’s COUNTIF function comes in handy.

## The COUNTIF Function

The COUNTIF function is an Excel function that counts the number of cells in a range that meet specific criteria. The syntax for 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 you want to apply. For example, to count the number of cells that contain the value “Apple” in the range A1:A10, you would use the following formula:

``=COUNTIF(A1:A10,"Apple")``

The COUNTIF function can also be used to count cells that match one of two given values.

## Counting Cells that Match One of Two Given Values

To count the number of cells in a range that match one of two given values, we can use the COUNTIF function twice and add the results together. The syntax for this formula is as follows:

``=COUNTIF(range,criteria1)+COUNTIF(range,criteria2)``

Where “range” is the range of cells you want to count and “criteria1” and “criteria2” are the two conditions you want to apply. For example, to count the number of cells that contain the values “Apple” or “Banana” in the range A1:A10, you would use the following formula:

``=COUNTIF(A1:A10,"Apple")+COUNTIF(A1:A10,"Banana")``

This formula will count all the cells in the range A1:A10 that contain either “Apple” or “Banana”.

## Using Wildcards to Match Partial Text

Sometimes you may want to count cells that contain a specific word or phrase, but you don’t know the exact spelling or formatting. In this case, you can use wildcards to match partial text. The asterisk (*) is used as a wildcard character that matches any number of characters. For example, to count the number of cells that contain the word “Orange” in the range A1:A10, regardless of the capitalization or formatting, you would use the following formula:

``=COUNTIF(A1:A10,"*Orange*")``

This formula will count all the cells in the range A1:A10 that contain the word “Orange” anywhere in the cell. ## 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.