Counting numbers in a range

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

dustortion

Hi,
I have a list of house prices and want to count how many are unde
70,000, between 70,000 and 80,000, between 80,000 and 90,000, etc. An
help would be greatly appreciated.
Cheers,

Dusti
 
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