counting a range

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
 
J

JE McGimpsey

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)
 
F

Frank Kabel

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))
 
Top