Hi

I have 5 groups numbered 1 - 5 respectively, there are over 500 rows with
each row belonging to various groups . I just want to be able to calculate,
say the No. 1 group to find out how many are belonging to it. I know you
could use a filter but I want the total to appear at the end of the sheet for
each individual group.

Example:

Row 1: 5022 Joe Bloggs Position 1
Row 2: 7895 Mary J Position 5
Row 3: 5689 Sarah H Position 1
Row 4: 4589 Jane D Position 4
etc

Total: Group 1 2 Staff
Group 4 1 Staff
Group 5 1 Staff etc

Assuming your group numbers are in cells D25000, and that you have the
integers 1-5 in cells E2:E6 - put this formula in F2 & copy it down to F3:F6

COUNTIF($D$2:$D$5000,E2)

"LittleAnn" wrote:

> Hi
>
> I have 5 groups numbered 1 - 5 respectively, there are over 500 rows with
> each row belonging to various groups . I just want to be able to calculate,
> say the No. 1 group to find out how many are belonging to it. I know you
> could use a filter but I want the total to appear at the end of the sheet for
> each individual group.
>
> Example:
>
> Row 1: 5022 Joe Bloggs Position 1
> Row 2: 7895 Mary J Position 5
> Row 3: 5689 Sarah H Position 1
> Row 4: 4589 Jane D Position 4
> etc
>
> Total: Group 1 2 Staff
> Group 4 1 Staff
> Group 5 1 Staff etc
>