View Single Post
  #1   Report Post  
mwrfsu
 
Posts: n/a
Default 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