How to count cells that aren’t blank in Excel

In our daily lives, the majority of activities or scenarios that happen to come across will always involve counting in one way or the other. Nearly everything depends on or revolves around counting in this world. We count to obtain the value of things numerically or in terms of numeral values.

The act of tallying a certain quantity to obtain or to reveal the number of items or several objects in a set is what we mostly refer to as counting. Counting is general and done in almost all aspects of life or our daily routines.

In most cases, we count in numbers that are to means we use numbers to identify the number of items or the number of objects. As said earlier, counting is done everywhere even when using excel sheets. In excel sheets we do the count of the number of rows, columns, cells, items in the rows, and columns and even the number of empty cells in an excel sheet is also counted.

To do a quick count of cells that are not blank in excel, we have some steps to follow, and some of the steps are discussed below in detail;

Step 1

Search for Microsoft Excel from the start button on your computer or laptop and open a blank excel sheet, into the blank excel sheet insert some data into it as in the case below.

Step 2

Now that the excel sheet has been created and data inserted into it, next, we are going to have a count of all the cells that are not blank and get their correct tally. To do this we are to use the COUNTA function.

This function will count the number of cells that are not blank and give the result. To count the cells from cell B2 to cell D6, we write the formula =COUNTA (B2: D6) on the formula bar and the result will be displayed on cell C7 which is also referred to as the result cell.

The total number of all the cells that are not blank is 14 from the above scenario.