COUNTIFS

Counts cells matching multiple conditions.

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

Examples

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

	A
1	10
2	20
3	30

Result 2

Syntax

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

criteria_range1: range required
criteria1: any required
criteria_range2…: range optional
criteria2…: any optional

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.