# Count cells less than in Excel and Google Sheets

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

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

### A:A = Range

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

# Count cells less than in Excel

How to count cells less than in Excel?

# COUNT CELLS LESS THAN — 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 less than in Google Sheets

How to count cells less than in Google Sheets?

# COUNT CELLS LESS THAN — 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