How To Use Excel Countif Function In Excel

How To Use Excel Countif Function In Excel

Excel Countif function is a very powerful function in excel especially if you are working with numerous number of data in a database. People can use countif function according to their necessity but today I am going to show how Excel countif function can be used to check and match data in one column to another. This excel countif function is so interesting that it can be used as a powerful database function. In this very article I am going to cover another powerful and simple excel function which you might or might not be aware off.

How countif function works

Let’s start the tutorial about countif function basically important for database clerks, accountants, bookkeepers as well as to an auditor.

From the figure above,

Column A contains some random names.  Similarly Column C also contains some random name but you can see that in this column there are some names common to the Column A. Now you may ask what are we going to do with this???  Let’s get in, Over here we are using excel countif function to check which of the cell in “Column C” contains the name from “Column A”.

Create a random column, over here in this tutorial I am choosing “Column E” to insert my excel countif function.

From the figure, I inserted excel countif function in “Column E3” as: =countif($A$3:$A$11,C3)

What I did was, I fixed the Range with $ sign, $ sign is used to fix the cell i.e. if you want to fix A3 in carrying out any of the calculations, you can do it by using the $ sign as $A$3. Now I have covered a range which is  ”A3 to A11” and it is fixed. Then, I typed C3 as my criteria i.e. it will search if there is a name called “ Raju Dahal” in the given range of column A.  Then simply, copy the formula in E3 and drag it to E11. What it does is, if the name in a particular cell in column C has its match in any cell of column A then it will show “1”  in the Column E, if not then it will show “ 0”.

You can even select the whole column A(Range) if you don’t want to go with that $ sign as simply with the formula =countif(A:A,C3). That’s what is did in Column F. The other process is same as previous.

The next function, small but interesting function in excel is proper, I don’t want to or I guess I don’t need to explain what this function does coz, you might already have figured it out by looking at the figure.

Match the format of the names in “Column C” with “Column G”. What I did was, just inserted a proper function with =proper(C3) in “Column (G3)” and drag that to G11. You can see the difference.

If you have any questions regarding these two functions then you can always comment on the comment box, I shall be answering your answers as much as it is possible. If you like this short tutorial about excel countif function and proper function, then I shall appreciate if you share this article in any of the social media and if you don’t want to miss similar tutorials like this you can always subscribe to by blog through email.  Thank you.

Post a Comment