Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating totals from COUNTA function
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! |
#2
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating totals from COUNTA function
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? Just SUM it up? Assuming you have your COUNTA's for each team in I1:L1. Then in M1: =SUM(I1:L1) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "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! |
#3
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating totals from COUNTA function
Thanks Max! It worked great!
"Max" wrote: 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? Just SUM it up? Assuming you have your COUNTA's for each team in I1:L1. Then in M1: =SUM(I1:L1) -- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "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! |
#4
Posted to microsoft.public.excel.newusers
|
|||
|
|||
Calculating totals from COUNTA function
You're welcome ..
-- Max Singapore http://savefile.com/projects/236895 xdemechanik --- "MW" wrote in message ... Thanks Max! It worked great! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Calculating totals from COUNTA function | Excel Discussion (Misc queries) | |||
Counta function question | Excel Worksheet Functions | |||
Calculating totals | Excel Discussion (Misc queries) | |||
Help calculating totals | Excel Discussion (Misc queries) | |||
COUNTA Function not working =COUNTA(C3:C69,"NH") | Excel Worksheet Functions |