Forum Discussion

kittenmeants's avatar
kittenmeants
Brass Contributor
Jul 14, 2023
Solved

Formula: Another way to count blank/empty cells

I need support in counting the number of empty cells (blanks cells), that do not have data entered, but omitting the title headers. On a (very) small scale this is what our tracking looks like. We ne...
Formulas and Functions
  • HansVogelaar's avatar
    HansVogelaar
    Jul 14, 2023

    kittenmeants 

     

    Are the teams such as 2.1 and 3.8 all numbers? If so:

     

    With Team headers in column A and Met Goal in column 😧

     

    =SUM(ISNUMBER(A2:A1000)*(D2:D1000=""))

Faisal1775's avatar
Faisal1775
Brass Contributor
Jul 17, 2023

kittenmeants 

In Excel or other spreadsheet software, you can count blank or empty cells using the "COUNTBLANK" function. However, there is another way to achieve the same result using a combination of functions. One common approach is to use the "COUNTIF" function alongside some other functions like "ISBLANK" or "IF."

Here's the formula using this method:

excelCopy code
=COUNTIF(range, "")

In this formula:

  1. "range" refers to the range of cells you want to count. For example, if you want to count the blank cells in column A from A1 to A10, the range would be "A1:A10."

  2. The empty double quotes "" represent the criteria for the "COUNTIF" function to count blank cellshttps://www.substancelaw.com

The "COUNTIF" function will count the number of cells within the specified range that match the specified criteria, which, in this case, are the empty cells.

Keep in mind that this method counts truly blank cells (cells with no value at all) rather than cells that appear blank but may contain formulas that return empty strings or spaces. If you want to count cells that appear blank but may contain empty strings, you might need to adjust the formula accordingly, for example, using the "IF" function to check for empty strings or spaces within the cells.

Resources