| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.programming
|
|||
|
|||
Formula want work
can you tell me why this wont work? I am trying to find how many days in
column H2:H232 are less than 8 if in column D2:D232 the month is January. I used the formula below as an array formula but it is just counting all of the days and not the one's less than 8. {=COUNT(IF(D2:D232="January",H2:H232,"<8"))} |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| formula to work in a 3-d reference with 2 work books | Excel Worksheet Functions | |||
| Sorting the cells of a formula causes the formula to not work | Excel Worksheet Functions | |||
| Why does this formula not work? | Excel Worksheet Functions | |||
| A search for $ in a formula use to work now it does not work | Excel Discussion (Misc queries) | |||
| extract a foldername with a formula-update formula does not work | Excel Programming | |||
Threaded Mode
