Use =COUNTIF()

Say we have values from A1 thru A1000. In B1 enter:
=COUNTIF(A1:A1000,"<" & 601)

In B2 enter:
=COUNTIF(A1:A1000,"<" & 1001)-B1

In B3 enter:
=COUNTIF(...)-B1-B2 , etc.

--
Gary''s Student - gsnu200770


"$cruncher" wrote:

What function can I use to analyze the numerical data in a spreadsheet and
create a table of values? Such as x no of items within value range $0 to
$600, x no. of items within value range $601 to $1,000, etc.? Thanks you
--
$cruncher