Home |
Search |
Today's Posts |
#1
|
|||
|
|||
> and < criteria in one single expression in excel
i would like to know how to filtered out two different criteria for example
less than 40 and greater than 60 in one expression at COUNTIF function. example of the formula would be appreciated. |
#2
|
|||
|
|||
One way:
=COUNTIF(A:A,"<60") - COUNTIF(A:A,"<40") another =SUMPRODUCT(--(A1:A1000=40),--(A1:A1000<=60)) See http://www.mcgimpsey.com/excel/doubleneg.html for an explanation of how the "--" works. In article , ExcelLEarner wrote: i would like to know how to filtered out two different criteria for example less than 40 and greater than 60 in one expression at COUNTIF function. example of the formula would be appreciated. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? | Excel Discussion (Misc queries) | |||
Excel should allow multiple hyperlinks in a single cell | Excel Discussion (Misc queries) | |||
Paste rows of numbers from Word into single Excel cell | Excel Discussion (Misc queries) | |||
Removing single quote from an excel sheet | Excel Discussion (Misc queries) | |||
Excel Expression | Excel Discussion (Misc queries) |