Table of Value Ranges   

What function can I use to analyze numerical data in a column and return the 
number of items into a table showing ranges of values?  Such as X no. of 
items in value range $600 to $1,000; X no. of items in value range $1001 to 
$2,000, etc.  Thanks!
-- 
$cruncher

date: Fri, 22 Feb 2008 12:43:00 -0800   author:   $cruncher

Re: Table of Value Ranges   

The countif function will do this.  I have posted an example at 
www.tejniya.co.uk, under documents and excel.

Manish

"$cruncher"  wrote in message 
news:8180BF7F-049E-4C7C-B704-283FA5B96A38@microsoft.com...
> What function can I use to analyze numerical data in a column and return 
> the
> number of items into a table showing ranges of values?  Such as X no. of
> items in value range $600 to $1,000; X no. of items in value range $1001 
> to
> $2,000, etc.  Thanks!
> -- 
> $cruncher

date: Mon, 25 Feb 2008 21:05:10 -0000   author:   mvk