Manuals/calci/COUNTIF
COUNTIF (R, C)
Where r is the range of cells and c is the criteria in the form of a number, expression, cell reference, or text.
This function calculates the number of cells within a range.
COUNTIF
Syntax
Examples
Description
Lets see an example,
COUNTIF(R,C)
B C
'
P 50
Q 65
R 90
P 151
=COUNTIF(B2:B5,"P") is 2
=COUNTIF(C2:C5,">66") is 2
| Column1 | Column2 | Column3 | Column4 | |
| Row1 | P | 50 | 2 | |
| Row2 | Q | 65 | 2 | |
| Row3 | R | 90 | ||
| Row4 | P | 151 | ||
| Row5 | ||||
| Row6 |
