The second argument of the functions takes a logical operator of other then that checks for the blank cell. The function thus gives the non-blank cell count.
Using COUNTIF for non blank cells.
How to count cell that are not blank
Use MS Excel's CELL() formula to find the address of a cell
Counts the number of cells within a range that meet the given criteria
Create a new account
I already have an account
You haven't saved the current formula!
Are you sure to continue?
You haven't save the current formula!
Made with in Istanbul
START LEARNING EXCEL with SHEETZOOM