Calculate number cells depending on criteria

[harold1265]

Hi, 

I want to know how many cells are between my criterias. Ex: I want to know how many cells have a value between 1700 to 2200. 

I have tried a couple of formulas. Only seems to give me the cells that have 1700 or 2200 but not what is in between. 

What is the correct formula?

[#2]

@harold1265 

Use

=COUNTIFS(range, ">=1700", range, "<=2200")

where range is the cell range in which you want to count these values.