MrExcel Publishing
Your One Stop for Excel Tips & Solutions

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

=========