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")