Home |
Search |
Today's Posts |
#1
|
|||
|
|||
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 |
#2
|
|||
|
|||
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 |
#3
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Zero values in a log chart | Charts and Charting in Excel | |||
Second serie doesn't use X-as values | Charts and Charting in Excel | |||
Counting Values | Excel Discussion (Misc queries) | |||
Counting values within a Date Range | Excel Discussion (Misc queries) | |||
Need to sum values of columns 1 - 13 and 4 - 15 | Excel Worksheet Functions |