Remember Me?

#1
December 5th 04, 04:35 AM
 ExcelLEarner Posts: n/a
> 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
December 5th 04, 04:54 AM
 JE McGimpsey Posts: n/a

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.

 Posting Rules Smilies are On [IMG] code is On HTML code is OffTrackbacks are On Pingbacks are On Refbacks are On

 Similar Threads Thread Thread Starter Forum Replies Last Post mrpb Excel Discussion (Misc queries) 1 January 18th 05 01:51 PM Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM Hari Excel Discussion (Misc queries) 2 December 3rd 04 09:53 PM Yubasus Excel Discussion (Misc queries) 2 November 26th 04 12:41 AM

All times are GMT +1. The time now is 06:10 AM.