Use an array function. Array functions perform individual calculations on multiple cells simultaneously. But to get them to work, you must hold down CTRL and SHIFT while pressing ENTER after typing in the formula.
Here's the formula. Replace "_GT_" and "_LT" with the appropriate signs. For some reason this site erases them upon posting... The pointed brackets will be automatically created by Excel after you hold down CTRL and SHIFT and press ENTER:
={SUM(IF(I8:I24_GT_=75,IF(I8:I24_LT_90,1,0),0))}
Knightly
Quote:
|
Originally Posted by mwrfsu
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 |