Forum Discussion
Calculate number cells depending on criteria
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...
Use
=COUNTIFS(range, ">=1700", range, "<=2200")
where range is the cell range in which you want to count these values.