> and < criteria in one single expression in excel

Guest · Dec 5, 2004

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.

JE McGimpsey · Dec 5, 2004

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.

> and < criteria in one single expression in excel

Guest

JE McGimpsey