COUNTIF

Counts cells that match a condition.

Excel: Not checked yet
Google Sheets: Not checked yet
Returns: Number

Examples

=COUNTIF(A1:A3, ">15")

	A
1	10
2	20
3	30

Result 2

Syntax

COUNTIF(range, criteria)

range: range required
criteria: any required

AVEDEVAverage of absolute deviations from the mean. AVERAGE.WEIGHTEDAverage of values weighted by a second range. AVERAGEAAverages values including text and logicals. AVERAGEIFAverages cells that match a condition. AVERAGEIFSAverages cells matching multiple conditions. BETA.DISTBeta distribution.