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.