Dave Bruns
Count cells that do not contain
In this example, the goal is to count cells that do not contain a specific substring. This problem can be solved with the COUNTIF function or the SUMPRODUCT function. Both approaches...Read more
Count cells that contain specific text
In this example, the goal is to count cells that contain a specific substring. This problem can be solved with the SUMPRODUCT function or the COUNTIF function. Both approaches are explained below. The SUMPRODUCT version can also perform a case-sensitive count.
COUNTIF function...Read more
Count cells that end with
In this example, the goal is to count cells in the range B5:B16 that end with specific text, which is provided in column D. For convenience, the range B5:B16 is named data.
COUNTIF function
The simplest way to solve this problem is with the COUNTIF function ...Read more
Count cells that begin with
In this example, the goal is to count cells in the range B5:B16 that begin with specific text, which is provided in column D. For convenience, the range B5:B16 is named data.
COUNTIF function
The simplest way to solve this problem is with the ...Read more
COUNTBLANK Function
The COUNTBLANK function returns a count of empty cells in a range. Cells that contain text, numbers, errors, spaces, etc. are not counted. Formulas that return an empty string ("") are counted as blank. COUNTBLANK takes just one argument, range, which must be a cell...Read more
Count cells not equal to
In this example, the goal is to count the number of cells in column D that are not equal to a given color. The simplest way to do this is with the COUNTIF function, as explained below.
Not equal to
In Excel, the...Read more