To count the number of cells that have values greater than a particular number, you can use the COUNTIF function. In the generic form of the formula rng represents a range of cells that contain numbers, and X represents...

If you want to find out what values in one list are missing from another list, you can use a simple formula based on the COUNTIF function.
The COUNTIF function counts cells that meet supplied criteria, returning the...

To check to see if a cell contains more than one substring, you can use a formula based on the COUNTIF function.
In the example shown, the formula in C5 is:
=IF(SUM(COUNTIF(B5,{"*abc*","*aaa*...

Note: Excel contains many built-in "presets" for highlighting values with conditional formatting, including a preset to highlight duplicate values. However, if you want more flexibility, you can highlight duplicates...

To count the number of cells that contain a certain number of characters text, you can use the COUNTIF function. In the generic form of the formula (above), rng is a range of cells, and "?" is a wildcard matching any...

To count the number of cells that contain text (i.e. not numbers, not errors, not blank), use the COUNTIF function and a wildcard. In the generic form of the formula (above), rng is a range of cells, and "*" is a...

One way to track attendance is with simple formulas based on the COUNTIF function. In the example shown, the formula in M5 is:
=COUNTIF(C5:L5,"x")
How this formula works
This formula simply uses COUNTIF...

To count cells that contain either one value or another, you an either use a helper column then tally up the count, or a more complex single cell formula.
Background
When you count cells with "OR" criteria, you need...

To count cells not equal to many things (i.e. not equal to x, y, z, etc.), you can use a formula based on COUNTIF, SUMPRODUCT, and COUNTA.
In the example shown, the formula in H5 is:
=COUNTA(B4:C9)-SUMPRODUCT(COUNTIF...

To compare lists and highlight values that exist in one but not the other, you can apply conditional formatting with a formula based on the COUNTIF function. For example, to highlight values A1:A10 that don't exist C1:...

To count the number of cells that begin with certain text, you can use the COUNTIF function. In the generic form of the formula (above) rng is a range of cells, txt represents the text that cells should begin with, and...

This examples shows how to calculate a volunteer hour requirement. The requirement is to have 15 volunteer hours, with at least 5 in each category. The formula in F6 is:
=AND(COUNTIF(C6:E6,">=5")=3,SUM(C6...

To display a check mark if the value passes some kind of test, you can use a formula based on the IF function together a symbolic font like Wingdings.
In the example show, the formula in C5 is:
=IF(COUNTIF(allowed,B5...

Note: Excel has a built-in data validation rules for dropdown lists. This page explains how to create a your own validation rule for lists when you don't want the dropdown behavior.
To allow only values from a list in...

To track student class enrollment when classes may appear in any order, you can create a table with additional columns, one for each class, to mark and count enrollment. In the example shown, the formula in G6 is:
=...