Count cells equal to

Count cells equal to

Generic formula 

=COUNTIF(range,value)
Related formulas 
Count cells that do not contain
Count cells that contain text
Cell contains specific text
Running count of occurrence in list
Summary count with COUNTIF
Count cells that contain either x or y

Explanation

To count the number of cells equal to a specific values, you can use the COUNTIF function.

In the example shown, G6 contains this formula:

=COUNTIF(D5:D11,"red")

How this formula works

The COUNTIF function is fully automatic — it counts the number of cells in a range that match the supplied criteria.

For range, we use D5:D11, which contains colors. For criteria, we simply use "red".

COUNTIF returns the count of values in D5:D11 that are equal to "red".

Note: when text values are supplied directly as criteria, they need to be enclosed double quotes (""). If you have a criteria in another cell, you can supply the cell address as criteria without quotes, as seen in this example.

Count cells equal to

Generic formula 

=COUNTIF(range,value)
Related formulas 
Count cells that do not contain
Count cells that contain text
Cell contains specific text
Running count of occurrence in list
Summary count with COUNTIF
Count cells that contain either x or y

Explanation

To count the number of cells equal to a specific values, you can use the COUNTIF function.

In the example shown, G6 contains this formula:

=COUNTIF(D5:D11,"red")

How this formula works

The COUNTIF function is fully automatic — it counts the number of cells in a range that match the supplied criteria.

For range, we use D5:D11, which contains colors. For criteria, we simply use "red".

COUNTIF returns the count of values in D5:D11 that are equal to "red".

Note: when text values are supplied directly as criteria, they need to be enclosed double quotes (""). If you have a criteria in another cell, you can supply the cell address as criteria without quotes, as seen in this example.