If we need to count the number of words in a range, in Microsoft Excel 2010 and 2013, we have to use the COUNTIF formula.
COUNTIF function is used for count the text or numbers on the basis of multiple criteria.
The Syntax of COUNTIF: – =COUNTIF(Range,Criteria)
We can use this function with the multiple ways, you can find the below mentioned arguments, with the formula types and explanation.
Note: – We can count the duplicate text or number in row and columns.
Let’s take an example and understand how we can use the COUNTIF function to multiple ways.
We have student’s score data. Column A contains Student’s name, column B contains Subjects and column C contains Scores %age.
We need to count the cells in Subject column which are contains the end words with “ce”.
To Count the cells on the basis on end letter follow below given steps:-
We count the cells which contains the text in Subjects column.
To Count the cells which are contains text follow below given steps:-
We count the cells which donot contains text in Score column.
To Count the cells which are not contains the text follow below given steps:-
We count the duplicity in the Student’s Name column.
Count the cells which are duplicate in a range follow below given steps:-
This is how we can use COUNTIF function in Excel to count the duplicity in the data.
The applications/code on this site are distributed as is and without warranties or liability. In no event shall the owner of the copyrights, or the authors of the applications/code be liable for any loss of profit, any problems or any damage resulting from the use or evaluation of the applications/code.