Try this array formula:

=SUM(IF(datarange>=min,IF(datarange<max,1,0)))

where datarange is your range of data and min and max are the cells that

represent the lower and upper limits of your sort.

Hold the shift & control key and hit enter, and the formula should appear in

brackets { }

Alan

>HELP: Sorting Ranged Data ?

>Here's an interesting problem.

>I'am bit stuck with this one.

>Essentially the problems is as follows:

>I have a set of data:

> Tender values for Substructures:

> Tender 1 = 20000

> Tender 2 = 30000

> Tender 3 = 15000

> Tender 4 = 18000

> Tender 5 = 19000

> Tender 6 = 45000

>What I want to achive is to take the above an sort it into ranges:

>indicating how many tenders fall into each range.

> 0 to 10000 =0

> 10001 to 20000 =4

> 20001 to 30000 =1

> 30001 to 40000 =0

> 40001 to 50000 =1

>and from this draw a graph. With the ranges shown and number of

>occurancies in each range.

>I know what I want, but don't how to achive this in Excel.

>Any help or observations would be greatly appreciated.

>Regards

>Ike