counting a range

  • Thread starter Thread starter dustortion
  • Start date Start date
D

dustortion

Hi,
Would anyone know a good way to count the number of times a numbe
appears in a range. I have a bunch of house prices, and want to coun
the number that are less than 70000, 70000 to 79000, 80000 to 90000
etc. Any help would be greatly appreciated.

Thanks.

Dusti
 
One way:

Assume your prices are in A1:Ax. then put this in B1:

B1: 70000
B2: 80000
B3: 90000
B4: 100000
....
B14: 200000

Then select C1:C15 and array-enter (CTRL-SHIFT-ENTER or CMD-RETURN):

=FREQUENCY(A1:Ax,B1:B14)
 
Hi
use COUNTIF. e.g.
=COUNTIF(A1:A100,"<70000")

and
=COUNTIF(A1:A100,">=70000")-COUNTIF(A1:A100,">=80000")
or as an alternative
=SUMPRODUCT(--(A1:A100>=70000),--(A1:A100<80000))
 
Back
Top