fx =COUNTIFS(A1:A100,"Active",B1:B100,">30")ABCJan Score8782.3Feb Score92Mar Score78
📈 Statistical

COUNTIFS Formula for Statistical

Count cells meeting multiple conditions. Copy-paste ready for Excel, Google Sheets, and Airtable.

=COUNTIFS(A1:A100,"Active",B1:B100,">30")
When you need this: When you need to count active users (status in A1:A100) who have spent more than $30 (spending in B1:B100).

How it works

  1. 1Specify the first criteria range (A1:A100) and criterion ("Active").
  2. 2Add the second criteria range (B1:B100) and criterion (">30").
  3. 3Count only rows where ALL conditions match.

Variations

COUNTIFS with 3 conditions
=COUNTIFS(A1:A100,"Active",B1:B100,">30",C1:C100,"Premium")
COUNTIFS with date range
=COUNTIFS(A1:A100,">=2024-01-01",A1:A100,"<=2024-03-31")

Related Formulas

AVERAGE — Calculate the average of a rangeStatisticalCOUNTIF — Count cells that meet a conditionStatisticalMAX / MIN — Find the largest or smallest value in a rangeStatisticalAVERAGEIF — Average values meeting a conditionStatistical

Need a formula that's not here?

Generate custom formula →