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.

Previous: Excel Formulas - Compare cells to meet multiple criteria within a row
Next: Excel Formulas - Count number of matches between two columns