BIG FILE LOTS of Variables that need to be counted
 

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.

BIG FILE LOTS of Variables that need to be counted
 

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.