We will use COUNTIF function with logical criteria "<>" i.e. other then and count the non blank cell.
Countif if not a blank cell
Using COUNTIF for non blank cells.
Counting cell that are not blank in a given cell range.
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