Course Content

Course Content


How to use COUNTIF function

Now we will learn that how we can use countif function in MS Excel. By name it means that it should count if any special condition which we mention is true.

Show to count any particular thing from any column that how much time it is used in our data, than we can use this function as, '=countif(A1,G1' where A1 is the column from where we want value, and B1 is that reference value to which condition should be given.

We can also use this function with another function according to our requirement, for example if we want to have the total salary for those who are from Bombay city mentioned in a table, than we can use ‘sum’ and ‘countif’ function together.


COUNTIF is one of the most powerful and frequently-used functions in Excel. CountIF is a simple yet powerful excel formula that counts the number of cells containing numbers and the numbers within the list of arguments. It can be used to count all cells containing numbers (e.g. in a range of cells), or to count only those cells with a specific value (e.g. in a range of cells, or one specific value).

The COUNTIF function is used to count the number of items in a list based on a given criteria. It is also known as the COUNT function.The COUNTIF function is used to determine how many cells contain a specific value within a range of cells. An example of the COUNTIF function would be: COUNTIF(A1:A10,B1)

The count function in Excel is used to find the total number of cells that contain data. You can also use this function to find the total number of rows, columns, or records in a given range. If you are looking through a list of numbers and want to make sure that you have counted them all, use the sum function rather than counting them by hand. Excel is spreadsheet software that has been around for years. It is one of the most used office software and has a variety of functions and features. The count function in Excel returns the number of cells in a given range of cells.

Recommended Courses

Share With Friend

Have a friend to whom you would want to share this course?

Download LearnVern App

App Preview Image
App QR Code Image
Code Scan or Download the app
Google Play Store
App Store
397K+ Downloads
App Download Section Circle 1
4.57 Avg. Ratings
App Download Section Circle 2
13K+ Reviews
App Download Section Circle 3
  • Learn anywhere on the go
  • Get regular updates about your enrolled or new courses
  • Share content with your friends
  • Evaluate your progress through practice tests
  • No internet connection needed
  • Enroll for the webinar and join at the time of the webinar from anywhere