Count cell between two values in Excel and Google Sheets

To count cell numbers between two numbers you can use the COUNTIF function, for i.e. =COUNTIFS(A2:A10,">=10",A2:A10,"<=20") will count the number that is >=10 and <=20.

=COUNTIFS(A:A,">10",A:A,"<20")

A:A = Range, Condition 1 = ">10", Condition 2 = "<20

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

Count cell between two values in Excel

How to count cells between two values in Excel?
Count cell between two values in Excel

COUNT CELL BETWEEN TWO VALUES — EXCEL FORMULA AND EXAMPLE

Count cell between two values in Google Sheets

How to count cells between two values in Google Sheets?
Count cell between two values in Google Sheets

COUNT CELL BETWEEN TWO VALUES — GOOGLE SHEETS FORMULA AND EXAMPLE

Wild cards and regular expressions in Excel and Google Sheets

Wild cards and regular expressions