Counting values

[Jouni]

Hi,

I've posted this same question also to
http://groups.google.com/groups?hl=...oup=microsoft.public.excel.worksheetfunctions,
but I don't seem to get an answer and also I am a bit puzzled with the news
group names (
microsoft.public.excel.worksheet.functions vs
microsoft.public.excel.worksheetfunctions
) so I am repeating my question here, as this forum seems to be more active.

Thanks for any advice,
Jouni

--
Hello,

I'm banging my head to the wall with the following simple problem.

I have loads of data in a range. The data contain values between 0 and
50. I want to count with one function the number of values between 20
and 50. I know I can use
=COUNTIF(E:E,20)+COUNTIF(E:E,21)+COUNTIF(E:E,22)+... but it's not very
handy. Are there any better ways of accomplishing the same? Naturally,
=COUNTIF(E:E,">20") does not do it as it searches for entries with
">20", and without quotes it is not even possible to enter the
function.

Thanks in advance,
Jouni

 

[Frank Kabel]

Hi
=COUNTIF(E:E,">=20")-COUNTIF(E:E,">50")

 

[Jouni]

Excellent response, Frank. I just wonder what I've done yesterday when I
tried that and got absolutely nothing to work? =COUNTIF(E:E,">=20") seemed
to search for string entries ">20" and not values greater than 20.

Jouni