If you need to determine if a range or column contains specific text (a specific substring or partial text), you can use a formula based on the COUNTIF function with wildcards.
In the example shown, the formula in D5...

To generate a count with a percentage breakdown, you can use the COUNTIF or COUNTIFS function, together with COUNTA.
In the example shown the formula in H4 is:
=COUNTIF(category,F4)/COUNTA(category)
How this formula...

To test values to see if they begin with one of several characters (i.e. begin with x, y, or z) , you can use the COUNTIF function together with the SUM function.
In the example shown, the formula in C5 is:
=SUM(...

To count positive numbers in a range of cells, you can use the COUNTIF function. In the generic form of the formula (above) rng represents a range of cells that contain numbers.
In the example, the active cell contains...

To highlight duplicate values in two or more columns, you can use conditional formatting with on a formula based on the COUNTIF and AND functions.
In the example shown, the formula used to highlight duplicate values is...

To count matches in entire workbook, you can use a formula based on the COUNTIF and SUMPRODUCT functions. In the example shown, the formula in D5 is:
=SUMPRODUCT(COUNTIF(INDIRECT("'"&sheets&"'!...

To count the number of cells that contain values not equal to a particular value, you can use the COUNTIF function. In the generic form of the formula (above) rng represents a range of cells, and X represents the value...

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...

Note: Excel contains many built-in "presets" for highlighting values with conditional formatting, including a preset to highlight cells that begin with specific text. However, if you want more flexibility, you can use...

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

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 do not contain 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 not contain...

To get the nth MATCH with VLOOKUP, you'll need to add a helper column to your table that constructs a unique id that includes the count. If this isn't practical, you can use an array formula based on INDEX and MATCH...

If you need to count the number of cells end with certain text, you can easily do so with the COUNTIF function. In the generic form of the formula (above) txt represents the text that cells should end with, and "*" is a...

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...