Hi all,

I've an excel sheet of 3 columns. I want to collect some information like follows. Basically count occurrence of a range.

=COUNTIF(B:B, "<100")
=COUNTIF(B:B, "<200")
=COUNTIF(B:B, "<300")
=COUNTIF(B:B, "<500")
=COUNTIF(B:B, "<700")
=COUNTIF(B:B, "<1000")
=COUNTIF(B:B, "<1500")
=COUNTIF(B:B, "<2000")
something like that. May be you are not clear, on column B I have some values. I want to calculate each count as above and put them in cells.

Can anyone give me a solution. Doing it manually is a real mess.