Counting values
 

Hi,

I've posted this same question also to
http://groups.google.com/groups?hl=e...sheetfunctions,
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

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

"Jouni" wrote:

Hi,

I've posted this same question also to
http://groups.google.com/groups?hl=e...sheetfunctions,
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

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

"Frank Kabel" wrote in message
...
Hi
=COUNTIF(E:E,"=20")-COUNTIF(E:E,"50")

"Jouni" wrote:

Hi,

I've posted this same question also to

http://groups.google.com/groups?hl=e...sheetfunctions,
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