How to Count Cells Equal to A, B, or C in Excel

When working with Excel, you may often need to count how many cells contain specific values such as A, B, or C within a range. This is a common requirement in scenarios like grading systems, survey results, or category-based data analysis.

However, Excel does not provide a direct built-in function to count multiple specific values in a single step. You typically need to combine formulas or use more advanced techniques. In this article, we will walk you through three practical methods to count cells equal to A, B, or C: using Excel formulas, VBA, and a much simpler approach with Kutools for Excel.

• Count Cells Equal to A, B, or C Using Excel Formulas
• Count Cells Equal to A, B, or C Instantly with Kutools for Excel
• Count Cells Equal to A, B, or C Using VBA

Count Cells Equal to A, B, or C Using Excel Formulas

Excel formulas provide a flexible way to count cells that match multiple values such as A, B, or C. Although there is no single built-in function for counting multiple specific values at once, you can easily achieve this using the COUNTIF function.

For example, in the worksheet below, the Grade column contains values such as A, B, C, and D. If you want to count how many cells are equal to A, B, or C, you can use the following formulas.

A common and straightforward approach is to use multiple COUNTIF functions and add the results together.

Steps:

1. Select a blank cell where you want the result to appear.
2. Enter the following formula:

   =COUNTIF(A1:A10,"A") + COUNTIF(A1:A10,"B") + COUNTIF(A1:A10,"C")

3. Press Enter.

Result:

This formula counts each value (A, B, and C) separately and then sums the results to get the total count.

While this method is easy to understand and works in all Excel versions, the formula can become longer when you need to include more values.

To make the formula shorter and more efficient, you can also use an array constant within COUNTIF:

=SUM(COUNTIF(A2:A100,{"A","B","C"}))

Count Cells Equal to A, B, or C Instantly with Kutools for Excel

If you prefer not to work with formulas or want a faster solution, Kutools for Excel provides a built-in tool that simplifies this task significantly.

Kutools includes a Formula Helper that allows you to count cells equal to A, B, or C without writing any formulas manually.

Steps:

1. Select a cell to output the result, click Kutools > Formula Helper > Statistical > Count cells equal to A, B or C.

   

2. In the Formular Helper dialog box, configure the formula arguments:
   1. In the Range field, select the data range where you want to count cells.
   2. 2) Enter the values you want to count (such as A, B, and C) into the three criteria fields.
   3. Click OK.

      

Result:

The result is returned instantly without needing to remember or type any formulas.

Why use Kutools:

• No need to memorize formulas.
• Easy-to-use interface.
• Supports multiple criteria input.
• Ideal for beginners and frequent users.

This method is especially useful when working with complex datasets or when you need a quick and reliable solution.

Count Cells Equal to A, B, or C Using VBA

For users who prefer automation or need a reusable solution, VBA can be used to create a custom function to count multiple values.

Steps to Use the VBA Function:

1. Press Alt + F11 to open the VBA editor.
2. Click Insert > Module.
3. Paste the code into the module window.

   

   VBA code: Count cells equal to A B or C

   Function CountMultipleValues(rng As Range, ParamArray values() As Variant) As Long
       Dim cell As Range
       Dim i As Long
       
       For Each cell In rng
           For i = LBound(values) To UBound(values)
               If cell.Value = values(i) Then
                   CountMultipleValues = CountMultipleValues + 1
                   Exit For
               End If
           Next i
       Next cell
   End Function

4. Return to Excel and apply the following function.

   =CountMultipleValues(C2:C21,"A","B","C")

5. Press Enter to get the result.

   

Conclusion

Counting cells equal to A, B, or C in Excel can be achieved in several ways, depending on your needs and experience level.

• The Excel formula methods are reliable and widely supported, but may become complex with multiple criteria
• The VBA method offers flexibility and customization, but requires technical knowledge
• Kutools for Excel provides the easiest and fastest solution, allowing you to complete the task without writing any formulas

If you frequently work with multi-condition counting tasks, using Kutools can greatly simplify your workflow and improve efficiency.