| Home |
| Search |
| Today's Posts |
|
#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? |
| 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) | |||
Threaded Mode
