My spreadsheet gives a breakdown of employees by their teams within a
business unit; for example, lets say everyone listed in the spreadsheet works
in the U.S. Sales business unit and the teams are named North, South, East,
and West. The first and last names of all employees on the North team are
listed under "North Team"; the first and last names of all employees on the
South team are listed under "South Team", etc.

I used the COUNTA function to tally the number of employees on each team.
Is there a function I could use that would add up all the numbers in the
COUNTA cell so I can see the grand number of employees? Thanks in advanced!

Hi MW. Take a look at the Subtotal function on the Data Menu. To use it you
may need to add a helper column to add "North, South, East and West" next to
each employee's name. Also, all the employees will need to be listed in one
column. Sort based on North, South column and then subtotal Count on
employee name for each change in the North South column. HTH.
--
Sincerely, Michael Colvin


"MW" wrote:

My spreadsheet gives a breakdown of employees by their teams within a
business unit; for example, lets say everyone listed in the spreadsheet works
in the U.S. Sales business unit and the teams are named North, South, East,
and West. The first and last names of all employees on the North team are
listed under "North Team"; the first and last names of all employees on the
South team are listed under "South Team", etc.

I used the COUNTA function to tally the number of employees on each team.
Is there a function I could use that would add up all the numbers in the
COUNTA cell so I can see the grand number of employees? Thanks in advanced!

Thanks Michael!

"Michael" wrote:

Hi MW. Take a look at the Subtotal function on the Data Menu. To use it you
may need to add a helper column to add "North, South, East and West" next to
each employee's name. Also, all the employees will need to be listed in one
column. Sort based on North, South column and then subtotal Count on
employee name for each change in the North South column. HTH.
--
Sincerely, Michael Colvin


"MW" wrote:

My spreadsheet gives a breakdown of employees by their teams within a
business unit; for example, lets say everyone listed in the spreadsheet works
in the U.S. Sales business unit and the teams are named North, South, East,
and West. The first and last names of all employees on the North team are
listed under "North Team"; the first and last names of all employees on the
South team are listed under "South Team", etc.

I used the COUNTA function to tally the number of employees on each team.
Is there a function I could use that would add up all the numbers in the
COUNTA cell so I can see the grand number of employees? Thanks in advanced!

Guess I wasted some bandwidth responding to your multi-post in .newusers,
then. Please do not multi-post ..
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---