Looking up an interval

[Benjaminmin]

Hi Everybody,

I have a large data set of % values, about 6000 values ranging all the way from -100% to 100%

How do I construct a formula to lookup something like:
values between 0% and 20%
between 20% and 40%
etc. etc.

Lets say the column with the values is B1:B6000

I tried something as a countif(B1:B6000,"0>*>.2") but it didnt work.

Any suggestions?

Cheers

 

[VoG]

Try

=COUNTIF(B1:B6000,">0")-COUNTIF(B1:B6000,">0.2")

 

[Benjaminmin]

works like a charm, I feel so stupid for not having seen this.

thank you very much