This technique can be adapted to any combination of conditions.

Consider the formula

=(I8=75)*(I8<90)

It returns 1 for the numbers you want to count and 0 otherwise. Enter this
in a column to the right of I and copy down. The sum of the 1's is what you
want.

--
Gary's Student


"mwrfsu" wrote:


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