Home |
Search |
Today's Posts |
#1
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
I have a spreadsheet that has 30 columns and about 7000 rows. I need a total
count of how many employees are in a group of: different cost centers, and meet a certain status. To be counted they must be in a certain set of cost centers then meet be "management" in another column? Please help. |
#2
![]()
Posted to microsoft.public.excel.misc
|
|||
|
|||
![]()
Hi Scott
One way, assuming Cost centre in A and "Management" in D =SUMPRODUCT(($A$2:$A$7000="CostcentreA")*($D$2:$D$ 7000="Management")) I am assuming a header row for row 1. Change ranges to suit, but keep to equal dimensions. Change "CostcentreA" and "Management" to appropriate tests. Better still, take a look at using Pivot Tables to analyse the data in all sorts of ways. Take a look at the following sites http://peltiertech.com/Excel/Pivots/pivotstart.htm http://www.contextures.com/xlPivot02.html http://www.datapigtechnologies.com/f...es/pivot1.html http://www.edferrero.com/Tutorials.aspx -- Regards Roger Govier "Scott@CW" wrote in message ... I have a spreadsheet that has 30 columns and about 7000 rows. I need a total count of how many employees are in a group of: different cost centers, and meet a certain status. To be counted they must be in a certain set of cost centers then meet be "management" in another column? Please help. |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
![]() |
||||
Thread | Forum | |||
Run a Batch file with variables | Excel Discussion (Misc queries) | |||
disc full, saved to temp. file | Excel Discussion (Misc queries) | |||
Importing lots of CSV files into an XLS file as different workshee | Excel Discussion (Misc queries) | |||
Weird File Open/Save As Behavior | Excel Discussion (Misc queries) | |||
Links picking up values from an older version of linked file | Links and Linking in Excel |