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.

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.