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

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

It sounds like a nice fit.

Elliott Alterman wrote:
>
> 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

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


"Elliott Alterman" <(E-Mail Removed)> wrote in message
news:4b959de5$0$12436$(E-Mail Removed) ...
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

Thanks


Dave Peterson wrote:
> You may want to read about =frequency() in Excel's help.
>
> It sounds like a nice fit.
>
> Elliott Alterman wrote:
>> 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
>

Wow - great stuff. Thanks!

Elliott


Mike Middleton wrote:
> 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
>
>
> "Elliott Alterman" <(E-Mail Removed)> wrote in message
> news:4b959de5$0$12436$(E-Mail Removed) ...
> 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
>