help:formula
Posted by marky on January 11, 2002 2:49 AM
Is there a way to create a formula that counts the amount of numbers out of a serie of numbers when a certain criteria is set.
Example 24,35,36,38,37,48,42 set of numbers, what i need is a formula that counts the amount of numbers when the criteria is set numbers between >30 <40 the result of this exampl should be 4 numbers.
I would be very appreciative if someone could help me out.
Marky
Posted by Aladin Akyurek on January 11, 2002 3:26 AM
=COUNTIF(A2:A100,">"&E1)-COUNTIF(A2:A100,">"&E2)
where A2:A100 houses the numbers of interest, E1 the lower criterion number, and E2 the higher criterion number.
Aladin
=========
