Count number of cells in a range [closed]
Say I have column A with a certain number of cells, all of which have numbers. I need a way to count the number of cells in column A which fall into a given range, say [0.5,1]
I've tried COUNTIF but I don't know how to put two conditions in a single statement (ie: bigger than 0.5 and smaller than 1)
How would I go about doing this?