Excel CountIf

The COUNTIF and COUNTIFS functions are used to aggregate data as counts.


COUNTIF

Given the below worksheet:

A

B

C

1

Name

Score

Days Sick

2

Alice

91

0

3

Bob

54

7

4

Charlie

87

2

5

Daisy

84

0

6

Edward

76

1

Try:

=COUNTIF($B:$B, "<85")

The second parameter is called the criteria. A criteria can be any of:


COUNTIFS

Try:

=COUNTIFS($B:$B, "<85", $C:$C, 0)

Every range must have the same number of rows and columns. Otherwise a #VALUE! error propagates.


CategoryRicottone

Excel/CountIf (last edited 2025-04-08 16:51:34 by DominicRicottone)