How to count text in excel

In this tutorial, we will learn how to use the COUNTIF function with multiple criteria while also using the logical operators AND and OR. By combining the COUNTIF function with the logical operators AND and OR, you can create even more powerful formulas that can help you analyze your data.

Using COUNTIF with AND criteria.

In this example, we have two lists of names. One list is named “Comp 1” in the A column, and another is named “Comp 2″ in the B column.

Countifs function in excel with multiple criteria

In these two lists, we want to count how many times “John” and “Linda” are in the same row. To do this, we use the COUNTIFS function and the AND operator. Here is a step-by-step guide to using these features:

1. Select the cell where you want to apply the COUNTIFS function
2. In the formula bar, type in the formula: =COUNTIFS(A2:A7, “John”, B2:B7, “Linda”)
   
3. Press Enter to see the result, which shows the number of rows of cells that have “John” in A2:A7 and “Linda” in B2:B7.
   
4. In this example, the result is 2 because there are 2 rows of cells that have “JohnR
   how to count values in excel with condition
   how to count rows in excel with condition