| Home |
| Search |
| Today's Posts |
|
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
biconditional countif function in Excel
let me try it and get back to you. Thanks
"Max" wrote: One way using SUMPRODUCT .. Try something like this in say, B1: =SUMPRODUCT((A1:A1005)*(A1:A100<25)) B1 returns the count of values within A1:A100 which are greater than 5 but less than 25 Note that entire col references cannot be used -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "compliance data" wrote: 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
