Count number of cells in a range

asked 2012-07-30 21:36:41 +0200

Gabriel
71 ● 1 ● 1 ● 8

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?

Thanks!