Count number of cells in a range

[Gabriel1]

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!

[Gabriel1]

Got it: http://www.oooforum.org/forum/viewtopic.phtml?t=132089

[mariosv]

COUNTIF used finding words in multiple columns

I’m basically trying to find the condition when “racecar” and “shoe” are both in the same row, but in two different columns. Most of my searching has brought me to similar questions for Open Office, but with solutions that don’t appear to work. I get Error 502 for this formula: =COUNTIF((H2:H118,“racecar”)*(I2:I118,“shoe”)) SUMPRODUCT has also been recommended, but I don’t think that’s what I’m looking for.