# Count cells greater than and equal to in Excel and Google Sheets

=COUNTIF(A:A,">=10")

=COUNTIF(A:A,">="&B3) // Criteria as a cell reference

### A2 = data cell

Check below for a detailed explanation with pictures and how to use formulas in Excel and Google Sheets.

# Count cells greater than and equal to in Excel

How to count cells greater than and equal to in Excel?

# COUNT CELLS GREATER THAN AND EQUAL TO — EXCEL FORMULA AND EXAMPLE

1. =COUNTIF(A:A,">=10")

• Criteria within the formula and must be inside the quotation mark

2. =COUNTIF(A:A,">="&B3)

• Condition within the formula and must be inside the quotation mark

• Criteria as a cell reference

3. =COUNTIF(A:A,B4)

• Criteria as a cell reference

4. =COUNTIF(A:A,B5)

• Criteria as a cell reference

# Count cells greater than and equal to in Google Sheets

How to count cells greater than and equal to in Google Sheets?

# COUNT CELLS GREATER THAN AND EQUAL TO — GOOGLE SHEETS FORMULA AND EXAMPLE

1. =COUNTIF(A:A,">=10")

• Criteria within the formula and must be inside the quotation mark

2. =COUNTIF(A:A,">="&B3)

• Condition within the formula and must be inside the quotation mark

• Criteria as a cell reference

3. =COUNTIF(A:A,B4)

• Criteria as a cell reference

4. =COUNTIF(A:A,B5)

• Criteria as a cell reference

## Wild cards and regular expressions in Excel and Google Sheets

Wild cards and regular expressions