Use Counta To Count Nonblank Cells. The empty cells will not be counted using the COUNTA function and will be ignored. This becomes possible only by using the COUNTIF function which follows the defined criteria to get the desired output.
Step 2 Enter the formula in the cell as shown below to calculate the cells which are having some value. - Narrator The COUNTA function counts the number of cells. See how the machine-learning algoritm takes cell counting accuracy to the next level.
Step 1 Choose the data which have some cells are empty and some of them contain the values.
Lets say that the last row with data is 15 so 15 will be the last row with data and from row 4. Or dates and times as values. The COUNTA function is even easier to use you dont need to enter more than the cell range in one argument. COUNTA B3B13 There are however situations where the COUNTIF and COUNTA function return unexpected results if you are not aware of how they work.