If you have a range of cells in Excel and want to count the number of cells meeting a specific criterion, then the COUNTIF function is a great option to use. In this tutorial, we will illustrate how to use the COUNTIF function in Excel 2013.
To demonstrate the COUNTIF function, we will use a table of data that consists of Year and Value columns, and a criteria column where we’ve placed a value of 2000 to represent the year 2000.
To begin, enter the COUNTIF command, which takes two parameters. The first parameter is the range of cells that the criteria will be applied against. In our example, we will enter the range A2:A7 which represents the data to be tested for the criteria.
The second parameter is the criteria that will be applied against the range. This can either be a value or the reference to a cell that contains a value. In our example, we will enter D2, which contains the value 2000.
The COUNTIF function will test each value in the range A2:A7 to see if it matches the year 2000. After entering the two parameters, the COUNTIF function will return the value 1, which was calculated by examining the values in cells A2:A7 and counting only those cells that contain the value 2000.
This is a simple example of how to use Excel’s COUNTIF function. If you would like to see more examples or download the sample data we used for this tutorial, please visit our website at TechOnTheNet.com.
We hope this tutorial has been helpful in illustrating how to use the COUNTIF function in Excel 2013.