Count cells that do not contain

Want to learn more about how to count cells do not contain using excel spreadsheet?? This post will give you an overview of how to use COUNTIF formula functions to get the number of cells that do not contain using excel.

Syntax(Generic Formula)

=COUNTIF(range,”<>*txt*”)

How the COUNTIF & COUNTIFS WORKS

Excel has many syntax for a user who needs to specify on counting the total amount of cells with single or multiple criteria. For example, if you want to count cells based on more than one or more criteria, you can use the COUNTIF or COUNTIFS functions in Excel.

Figure 1: Example of count cells that do not contain

To count cells that do not contain, you can use the COUNTIF function. In the example shown, the formula in H13 is

=COUNTIF(D10:D18”<>”S”)

Difference Between COUNTIF & COUNTIFS

The difference between COUNTIF and COUNTIFS function is about the total number of condition that applies. While COUNTIF is designed to count the cells with a single condition, COUNTIFS function will let you have several criteria indifferent or in the same range as you wish.

=COUNTIFS(range”<>*?*”,rang”?*”)

By this tutorial, you have learned how to count the number of cells which don’t contain a specific text string.

Our customers love us!
“The expert was absolutely amazing and stuck with me the whole way through. They were polite, patient, seemed to want to genuinely help me and provided a solution that I would never have managed otherwise. I could not be more thankful for their support and solution. Thank you!” - - Chris T, in California

Leave a Comment

avatar