Excel Formulas - Count number of items in the list

Count number of items in the list

Syntax of used function(s)

```COUNTIFS(criteria_range1, criteria1, [criteria_range2, criteria2]…)
```

The COUNTIFS function applies criteria to cells across multiple ranges and counts the number of times all criteria are met.

Explanation

To count a values that appear in a list or a table the COUNTIFS function can be used. In this example we are going to count that, the number of students have a marks listed in the 1st semister column.

Formula

``````
=COUNTIFS(C:C,C6,D:D,D6)

``````

How the formula works

In the above example, the COUNTIFS function accepts two pairs of range and criteria, and return a count when all criteria matches. In the first range and criteria pair, the range is the full C column reference and the criteria is C6. This pair of range and criteria will return a count of every value in column C.
In the second range and criteria pair, the range is the full D column reference and the criteria is D6. This pair of range and criteria will return a count of every value in column D.
As both range and criteria pairs are appear in same COUNTIFS function, so there are link between column C and D, and COUNTIFS make a count of C and D column combination and appears in each row in the table.

﻿