Excel formula: Count cells that do not contain using COUNTIF function

How to Count Cells That Do Not Contain Certain Criteria

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.

Count cells that do not contain in Excel

Syntax(Generic Formula)

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

How COUNTIF & COUNTIFS work

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.

Still need some help with Excel formatting or have other questions about Excel? Connect with a live Excel expert here for some 1 on 1 help. Your first session is always free.

Did this post not answer your question? Get a solution from connecting with the expert.

Another blog reader asked this question today on Excelchat:

I need to be able to count if cells contain a specific word. If they do, then I want the column next to it to be a 1 or 0 depending if it contains that word or not.

An Excelchat Expert solved this problem in 27 mins!

I would like a formula to do the following: Count the number of cells that contain a value contained in another cell. The cells to be counted H2:I92 contains the same text as in T4. However, if the data contained in adjacent cells is the same, only count it once (ie if H3 and I3 both contain the text in T4).

An Excelchat Expert solved this problem in 15 mins!

how do i not count empty cells in my table

An Excelchat Expert solved this problem in 15 mins!

Post your problem and you'll get expert help in seconds