After reading this article you will be able to count rows at once that contain Text (Non Blank) and blank (both) in a given Data set. If you want to know read how many cells contain only text.
We have two columns Product and Detail. Our task is to find how many Product is Sold and Blank ones.
Formula to implement:
Download Your Example Excel File
COUNTBLANK: The Excel COUNTBLANK function returns the count of blank cells within the reference arguments ignoring number and text cells.
COUNTA: The Excel COUNTA function returns the count of numbers and text within the reference list of arguments ignoring blank cells.
Formula Explanation (step by step)
We can easily evaluate formula using F9 key.
Let’s break the formula into multiple small steps to understand its application.
Result: 7 ‘ Zero indicating blank
Returns counts all cells that are blank in the given range (C3 to C13).
Syntax: COUNTA(value1, [value2], …)
It counts all text containing cells in the range (C3 to C13).
Add first two formula in step 3
Step 3: COUNTBLANK(C3:C13)+COUNTA(C3:C13)
It adds both blank and text cells in column (C) returns count at once.