count

[Colin Matchett]

On a worksheet i have column that contains the length of
service (in monnths ) of each of my employees. I want to
a formulae that will segregate them into sertain groups
e.g 0-7, and count how many of each group i have. I have
tired using the countif and sum functions, but to no
avail. could someone please give me some direction? lots
of thanks

colin

[Dave Peterson]

Take a look at =frequency() in excel's help. I think that'll do what you want.

Colin Matchett wrote:
>
> On a worksheet i have column that contains the length of
> service (in monnths ) of each of my employees. I want to
> a formulae that will segregate them into sertain groups
> e.g 0-7, and count how many of each group i have. I have
> tired using the countif and sum functions, but to no
> avail. could someone please give me some direction? lots
> of thanks
>
> colin

--

Dave Peterson