How to count cells that start with a specific letter

The majority of activities or scenarios we happen to come across in our daily lives will always involve counting in one way or the other. Nearly everything depends on or revolves on 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 mean 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 cells that begin with a specific letter are also counted. Characters that begin with specific letters may include serial numbers, names of places, names of products, and many more.

To do a quick count of cells that start with a number, we have some steps to follow, and some of the steps are discussed below in detail;

Step 1

On your personal computer or laptop, open the excel sheet that you would like to count the cells with a specific letter if you do not have the excel sheet already created, open a blank excel sheet and record some data in it. Ensure your data has values that begin with similar letters to make our scenario effective.

Step 2

We are now going to obtain the tally of the number of cells that begin with a specific letter from the excel sheet we have just created. To do this, we are going to use the function COUNTIF.

We incorporate this function in the formula; =COUNTIF (B2: B7, D1). From this formula, B2 and B7 are the range of cells while D1 is the cell that we insert the specific character.

The cells that begin with the specific letter S are 4.

%d bloggers like this: