Archive of Mr Excel Message Board

Back to Forms in Excel VBA archive index
Back to archive home

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

Check out our Excel Resources

Re: help:formula

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

=========

This archive is from the original message board at www.MrExcel.com.
All contents © 1998-2004 MrExcel.com.
Visit our online store to buy searchable CD's with thousands of VBA and Excel answers.
Microsoft Excel is a registered trademark of the Microsoft Corporation.
MrExcel is a registered trademark of Tickling Keys, Inc.