| Home |
| Search |
| Today's Posts |
|
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
biconditional countif function in Excel
Use two COUNTIFs.
=COUNTIF(A1:A10,"<=9")-COUNTIF(A1:A10,"<5") This will return the count of numbers in A1:A10 that are between 5 and 9. Change the "<" and "<=" comparison operators to fit your needs. -- Cordially, Chip Pearson Microsoft MVP - Excel Pearson Software Consulting, LLC www.cpearson.com (email address is on the web site) "compliance data" <compliance wrote in message ... I need to find the number of cells in a column that are greater than value x and less than value y. I ahve tried vairations of punctuation spacing etc. with no luck. I am beginning that it is not possible. Anyone have any ideas? |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Excel - COUNTIF Function | New Users to Excel | |||
| Weakness in the Drag Function of Excel 2007 (Beta) | Excel Worksheet Functions | |||
| excel add-in function not persisting | Excel Discussion (Misc queries) | |||
| Excel function countif??? | Excel Worksheet Functions | |||
| I cant use englisch function names in a swedich version of excel | Excel Discussion (Misc queries) | |||
Threaded Mode
