COUNTIF

Counts cells that meet one condition.

Syntax

=COUNTIF(range,criteria)

Example:

=COUNTIF(B2:B10,”North”)

Counts the number of North-region records.

Numeric Example

=COUNTIF(C2:C10,”>=50000″)

Counts sales values greater than or equal to ₹50,000.

COUNTIFS

Counts records that satisfy multiple conditions.

Syntax

=COUNTIFS(criteria_range1,criteria1,criteria_range2,criteria2,…)

Example:

=COUNTIFS(B2:B10,”North”,D2:D10,”Laptop”)

Counts North-region Laptop sales records.