How to Count or Add Cells in Excel That Have Text – Step by Step

Currently 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 note 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 be able 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.

Use Excel on laptop and android

So first of all you must write: “= COUNT” so that the options appear and then click on “COUNTIF” in the menu that appears. Once you select it, you will be able to 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 complete and serious formula would be: “= 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 result that is displayed depends on the number of cells containing 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 writings. Although in box D the letter reaches cell 4; therefore cell D5 is blank.

Is there a function that allows me to sum cells with text in Excel?

Any function that is used to add the values within a range that meet all the criteria that you specified that function will be useful for our purpose.

Add Yes Excel

Also within Excel is possible to sum cells containing text and that 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.

Perform sums in Excel

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.

Specific cells in the workspace have to be included in the formula, so if it is found from the cell A2 to A10 the list of words and the B2 to B10 the list in number the formula would be: = ADDIF (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 wish 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.

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

Add Yes with two conditions

Suppose we need to add values ​​with more than one condition. For this we have in Excel with a function called “ADD IF SET“This is an arithmetic formula that adds numbers from the column that meet the conditions.

What is the Add If formula for cells that have text

The formula =ADD.YES(rank, criterion, (rank_sum)), just add the values ​​of the sum_range where the cells in the range are equal to the criteria. Depending on the configuration of your device you must use “,” or “;” in function.

To be able to do the sum when the cells are under several criteria, the function =SUM.IF.SET (sum_range, criteria_range1, criteria1). In this function you must add all the arguments that meet several criteria.

The sum_range is the range of cells to be added. Criteria_Range1, this range is compared to criteria1, they set a search pair that is used to find a range based on specific criteria. If any element of the range is found, the corresponding value (s) of the range are added. sum_range.

Criteria1, determine the cells of criteria_range1 to be entered. For example, criteria can be entered as 22, > 12, F4, oranges.

cells add text count

What other formulas to add letters in Excel can I use

=BDSUMA (database, field_name, criteria)

In this function, the first parameter is taken from the “database“where the sum will be executed and the second parameter is the column associated with the data to be added.

The third parameter contains the conditions that must be met to consider whether the count will take place. In this case, only the conditions that correspond to the “field name” of the “database“.

= IF (logical_test, (value_if_true), (Value_if_false))

In the internal part of the formula we find the “SUMARIF” function, which we have already seen in advance. After identifying the cells that appear in the range of the SUMARIF function, the third parameter is used to determine which values ​​should be taken into account in the sum.

In other words, the first two parameters define the rows, Meanwhile he third parameter defines the cells specifically to use for the sum.

text cell count excel

Sum values ​​in Excel if they meet a condition

Allows us Add the values or quantities, also text, of the cells that meet with the various criteria that we specify.

How to Sum Cells with Numbers and Text – Methods and Formulas

Allows us Add values, whether in quantity or text, so individual, ranks cell or one combination.

With formulas

= SUM (number1, (number2) …)

= SUMIF (range, criteria, (range_sum))

= BDSUMA (database, field_name, criteria)

= ADDIF.SET (sum_range, criteria_range1, criteria1)

= IF (logical_test, (value_if_true), (Value_if_false))

All the above formulas have been explained at the time.

With a useful function

The function more simple and more used on Excel Its the SUM, from this function there are combined functions which have been explained in this text.

With a user-defined function

If you have experience using excel you can use macros or VBA codes, and these functions must operate at Similar that exist in a way predefined in Excel.

How useful did you find this content?

Click on a star to rate!

Average score 0 / 5. Counting of votes: 0

So far, no votes. Be the first to rate this content.

I'm sorry this content was not useful for you!

Let me improve this content!

Tell me, how can I improve this content?

Deja un comentario