Forum Discussion
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...
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=""))
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=""))
Thank you! This worked exactly like I needed it to!