Reply
 
LinkBack Thread Tools Search this Thread Display Modes
  #1   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 62
Default 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.
  #2   Report Post  
Posted to microsoft.public.excel.misc
external usenet poster
 
Posts: 2,886
Default 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.



Reply
Thread Tools Search this Thread
Search this Thread:

Advanced Search
Display Modes

Posting Rules

Smilies are On
[IMG] code is On
HTML code is Off
Trackbacks are On
Pingbacks are On
Refbacks are On


Similar Threads
Thread Thread Starter Forum Replies Last Post
Run a Batch file with variables Stuartf Excel Discussion (Misc queries) 1 May 24th 06 05:55 PM
disc full, saved to temp. file charlies Excel Discussion (Misc queries) 7 May 18th 06 09:40 PM
Importing lots of CSV files into an XLS file as different workshee rmellison Excel Discussion (Misc queries) 4 January 5th 06 12:28 PM
Weird File Open/Save As Behavior [email protected] Excel Discussion (Misc queries) 0 December 9th 05 03:26 AM
Links picking up values from an older version of linked file Cate Links and Linking in Excel 4 October 20th 05 02:53 PM


All times are GMT +1. The time now is 02:45 AM.

Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
Copyright ©2004-2025 ExcelBanter.
The comments are property of their posters.
 

About Us

"It's about Microsoft Excel"