 |
 | Home | Contact Us | FAQ | Search & Site Map | Link to Us |
 | Sign In | Join | Other 45 Sites in Network |
| HomeDiscussionsAccessExcelInfoPathOutlookPowerPointPublisherWordDirectoryUser Groups Related Topics Outlook ExpressInternet ExplorerWindowsMS Server ProductsMore Topics ... |
MS Office Forum / Excel / New Users / September 2006CountIF function with two Criterium
Greetings - Is there anyway to make create a COUNTIF function with two different criterium (i.e. >100 and <=499.99, etc)? If not, can someone direct me to a function that can assist me in counting cells that have data with two or more criterium? Thanks! Try one of these: Count values greater than 100 and less than or equal to 499.99: =SUMPRODUCT((A1:A100>100)*(A1:A100<=499.99)) OR =COUNTIF(A1:A100,">100")-COUNTIF(A1:A100,"<=499.99") Does that help? *********** Regards, Ron XL2002, WinXP > Greetings - > [quoted text clipped - 5 lines] > > Thanks! Typo Ron! =COUNTIF(A1:A100,">100")-COUNTIF(A1:A100,">499.99")  SignatureRegards, RD --------------------------------------------------------------------------- Please keep all correspondence within the NewsGroup, so all may benefit ! --------------------------------------------------------------------------- > Try one of these: > [quoted text clipped - 19 lines] >> >> Thanks! Yikes! Thanks for catching that one, RD. *********** Regards, Ron XL2002, WinXP > Typo Ron! > [quoted text clipped - 22 lines] > >> > >> Thanks! =SUMPRODUCT(--(A1:A100>100),--(A1:A100<=499.99)) Regards, Alan. > Greetings - > [quoted text clipped - 5 lines] > > Thanks!
|
Reply to this Message |
 Sign In
 Join
 My Latest Posts My Monitored Threads My Blog My Photo Gallery My Profile My Homepage Start New Thread Enable EMail Alerts Rate this Thread
|
©2008 Advenet LLC Privacy Policy - Terms of Use
This website includes both content owned or controlled by Advenet as well as content owned or controlled by third parties.