Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Old December 5th 04, 04:35 AM
ExcelLEarner
 
Posts: n/a
Default > 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   Report Post  
Old December 5th 04, 04:54 AM
JE McGimpsey
 
Posts: n/a
Default

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
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Excel should allow multiple hyperlinks in a single cell mrpb Excel Discussion (Misc queries) 1 January 18th 05 01:51 PM
Excel 2003 FAILS, but Excel 2000 SUCCEEDS ??? Richard Excel Discussion (Misc queries) 1 January 5th 05 08:36 AM
Paste rows of numbers from Word into single Excel cell BecG Excel Discussion (Misc queries) 1 December 8th 04 04:55 PM
Removing single quote from an excel sheet Hari Excel Discussion (Misc queries) 2 December 3rd 04 09:53 PM
Excel Expression Yubasus Excel Discussion (Misc queries) 2 November 26th 04 12:41 AM


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

Powered by vBulletin® Copyright ©2000 - 2019, Jelsoft Enterprises Ltd.
Copyright 2004-2019 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"

 

Copyright © 2017