putting a set of values into a group of bins

[Elliott Alterman]

I have a column of numbers and I want to count how many are between 1 and 10, 11
and 20, 21 and 30, etc. I have been unable to develop any expression for the
COUNTIF function or a pivot table that works. Is one of those the way to go, or
is there another alternative.

Thanks

Elliott

 

[Dave Peterson]

You may want to read about =frequency() in Excel's help.

It sounds like a nice fit.

 

[Mike Middleton]

Elliott -

(1) For example, to count values between 11 and 20 inclusive, use
=COUNTIF(data_range,"<=20")-COUNTIF(data_range,"<11")

(2) FREQUENCY array-entered worksheet function, after you enter upper limits
for the bins on your worksheet

(3) Histogram tool of Excel's Analysis ToolPak (creates a frequency
distribution and optional chart)

(4) Group feature of pivot table

- Mike
http://www.MikeMiddleton.com


I have a column of numbers and I want to count how many are between 1 and
10, 11
and 20, 21 and 30, etc. I have been unable to develop any expression for the
COUNTIF function or a pivot table that works. Is one of those the way to go,
or
is there another alternative.

Thanks

Elliott

 

[Elliott Alterman]

Thanks

You may want to read about =frequency() in Excel's help.

It sounds like a nice fit.

 

[Elliott Alterman]

Wow - great stuff. Thanks!

Elliott