How to Count or Sum Cells Containing Text

At present we can make use of Microsoft office online , which is very useful. Mainly for people who use programs like Excel, since it is one of the best in terms of spreadsheets and much more.

In the application you can see that the work area is made up of grids and in each of them you can work by inserting numbers, letters, and it is even possible to apply styles or format in a table or cell in Excel , or  create a daily agenda .

Therefore, it is important to highlight that each space in the grid is known as a cell. So it will be easy to enter a data in each cell and therefore be able to add it. In this article we will show you how to count or sum cells containing text in Excel.

Excel: Easily count cells containing text

There are formulas to determine, count, or sum the values ​​that contain text . So cells containing numbers and blanks can be omitted from the work done. It is possible that one or two cells are located below the work area, for example if you are working from cells A1 to A5 and from D1 to D4 you can locate in cell A7 and place the formula.

So first you must write: «= COUNTIF» so that the options appear and then click on «COUNTIF» in the menu that appears. Once you select it, you will see how the formula is automatically marked in the cell where you are located: «= COUNTIF («.

When viewing the formula it is possible to select the entire range of cells in which you have worked. In this way the formula would be complete and serious: «= COUNTIF (A1: D5;” * ”)» . Then press enter and you will be able to see in the cell where the formula was the number in number of cells that have texts in the selected range.

The displayed result depends on the number of cells that contain texts , since cells with numbers will not be taken into account for the count. It is important to note that D5 is placed in the formula because it was indicated that up to the number 5 in cell A there are cells with writing. Although in box D the letter reaches cell 4; therefore cell D5 is blank.

Easily work in Excel with the add if formula

Also within Excel it is possible to add the cells that contain text and also contain a keyword. For example, you have a list of words with their respective result in number but you only want to count the words that contain certain letters , to determine how many products there are with that name.

So the keyword can be three letters containing the word like: “ant” in case the word is: pants. Therefore, having the keyword will count the number of cells that contain it, regardless of whether the word, shorts or pants is found in the work area, all cells that contain said letters will be located.

The specific cells of the work area must be included in the formula, so if the list of words is found from cell A2 to A10 and from cell B2 to B10 the list in number, the formula would be: = SUMARIF (A2 : A10, »* ant *», B2: B10) . It should be noted that to carry out the formula it can be located in any other cell as in D5 and the result would be for example: “add if it contains” ant “2500”.

The number is equal to the sum total of the number of numbers or articles that contain the keyword. So between pants and shorts there are 2500 units. This method can be used in shops , stores among others, who want to keep track of their products. Since they can get a quick result just by adding the number of cells that contain the same word.

All in all, Excel is a useful tool that can easily help people to be able to add or count the cells that contain text or keywords. Therefore, it is an office application used mostly in office work areas, among other similar ones.


Leave a Comment