table of value ranges

$

$cruncher

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
 
G

Gary''s Student

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.
 
T

T. Valko

One way:

Number values in the range A1:A100

How many are in the range 0 to 600 (inclusive):

=COUNTIF(A1:A100,">=0")-COUNTIF(A1:A100,">600")

Or, use cells to hold the boundaries:

C1 = 0
D1 = 600

=COUNTIF(A1:A100,">="&C1)-COUNTIF(A1:A100,">"&D1)
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Missing data when using TREND function 0
Getting a value within a range 5
Locating values in a range and bringing up the corresponding price 3
Auto populate value from one task to another in MS PROJECT 0
Finding the corresponding value in a range? 4
IF AND Function Date Range Issues 6
Lookup an exact Value with a range 8
Generate series according to range and increment 5

Top