| Home |
| Search |
| Today's Posts |
|
#1
|
|||
|
|||
Check to see if cell data is within a range
I want to count the number of cells with in a range that fall between a certain range. I can get it to work with one criteria but not when adding the second. For example, I want to count the number of cells between I8:I24 that are = 75 but < 90. This works for greater than 75 but not sure what to do for the less than 90. =COUNTIF(FIN!$I$8:$I$24,"=.75") Thank you for any help. -- mwrfsu ------------------------------------------------------------------------ mwrfsu's Profile: http://www.excelforum.com/member.php...o&userid=26459 View this thread: http://www.excelforum.com/showthread...hreadid=397850 |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| Inserting Filtered RC cell information into other worksheets | Excel Discussion (Misc queries) | |||
| Match function...random search? | Excel Worksheet Functions | |||
| Copy cell format to cell on another worksht and update automatical | Excel Worksheet Functions | |||
| Pulling data from 1 sheet to another | Excel Worksheet Functions | |||
| How do I check for duplications in a range of data (excel)? | Excel Worksheet Functions | |||
Threaded Mode
