| Home |
| Search |
| Today's Posts |
|
|
|
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
A row of values
I have a row of 50 numericlical values. Some are positive other
negative. Is there any way other than manually counting, I can determine how many values are say greater than 4? Or how many values are less than or equal to -2? Any formula help will be much appreciated. Thanks Skip |
|
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
A row of values
You would use the COUNTIF function. For your two questions...
=COUNTIF(1:1,"4") =COUNTIF(1:1,"<=-2") -- Rick (MVP - Excel) "Skip" wrote in message ... I have a row of 50 numericlical values. Some are positive other negative. Is there any way other than manually counting, I can determine how many values are say greater than 4? Or how many values are less than or equal to -2? Any formula help will be much appreciated. Thanks Skip |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
A row of values
On Oct 8, 3:57*pm, "Rick Rothstein"
wrote: You would use the COUNTIF function. For your two questions... =COUNTIF(1:1,"4") =COUNTIF(1:1,"<=-2") -- Rick (MVP Rick many thanks. One more question can I enter a cell number rather than a value like 4 or -2, and have the formula countif according to the value in the cell? |
|
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
|
A row of values
Assuming A2 has the value 4 in it...
=COUNTIF(1:1,""&A2) and if A3 has the value -2 in it... =COUNTIF(1:1,"<="&A3) -- Rick (MVP - Excel) "Skip" wrote in message ... On Oct 8, 3:57 pm, "Rick Rothstein" wrote: You would use the COUNTIF function. For your two questions... =COUNTIF(1:1,"4") =COUNTIF(1:1,"<=-2") -- Rick (MVP Rick many thanks. One more question can I enter a cell number rather than a value like 4 or -2, and have the formula countif according to the value in the cell? |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| calculate values in an unlimited range of cells in a column WITHOUTalso calculating values that had previously been filtered AGAINST? | Excel Discussion (Misc queries) | |||
| Excel 2007 doesnt show Y-axis values when the values are small. | Charts and Charting in Excel | |||
| Exclude #N/A values and Return Numeric values to consecutive cells in Single Row | Excel Worksheet Functions | |||
| create list of unique values from a column with repeated values? | Excel Worksheet Functions | |||
| Excel Compare values in columns & display missing values in a new | Excel Discussion (Misc queries) | |||
![Skip[_2_] is offline](https://www.excelbanter.com/images/SultanThemeVB3R/statusicon/user_offline.gif)
Hybrid Mode
