I don't know if I am asking this question correctly but here goes.
I have 30 rows of numbers that represent a homes square footage. They are all in column A. I want to be able to count the number homes square footages that are >0 and <=900. And then count any square footages that are >900 and <=1150 and so till oh lets say 2500. I tried using a =COUNTIF(A:A,"<"&C1) where C1 starts with my 900 and then C2 would be 1150 and so on. But here is where I go wrong obviously. I can not keep using the criteria "<"&Cx. Because it counts everything in "adds" it up. I tried writing the criteria as "<"&Cx&">="&Cx but that doesn't seem to work either.
Any ideas would help thanks!
I have 30 rows of numbers that represent a homes square footage. They are all in column A. I want to be able to count the number homes square footages that are >0 and <=900. And then count any square footages that are >900 and <=1150 and so till oh lets say 2500. I tried using a =COUNTIF(A:A,"<"&C1) where C1 starts with my 900 and then C2 would be 1150 and so on. But here is where I go wrong obviously. I can not keep using the criteria "<"&Cx. Because it counts everything in "adds" it up. I tried writing the criteria as "<"&Cx&">="&Cx but that doesn't seem to work either.
Any ideas would help thanks!