A Microsoft Office (Excel, Word) forum. OfficeFrustration

If this is your first visit, be sure to check out the FAQ by clicking the link above. You may have to register before you can post: click the register link above to proceed. To start viewing messages, select the forum that you want to visit from the selection below.

Go Back   Home » OfficeFrustration forum » Microsoft Excel » Worksheet Functions
Site Map Home Register Authors List Search Today's Posts Mark Forums Read  

Sumproduct?



 
 
Thread Tools Display Modes
  #1  
Old March 24th, 2010, 05:11 PM posted to microsoft.public.excel.worksheet.functions
hannah
external usenet poster
 
Posts: 66
Default Sumproduct?

Good Afternoon

Please could someone help....

I have a monster spreadsheet that tracks recruitment numbers and as part of
our monthly reporting i need to count various monthly stats

The information i need to summarise for each department is:

the number of internal candidates that were offered in each month
The number of external candidates that were offered in each month
the number of internal candidates that started in each month
The number of external candidates that started in each month,

Sample Data as follows:
Department Candiate type offer date Start date
Engineering Int 01/01/2010 01/02/2010
Supply Chain Int 31/12/2009 01/03/2010
Engineering Ext 01/01/2010 23/02/2010
Supply Chain Ext 15/01/2010 01/03/2010
Projects Ext 17/03/2010 01/04/2010
Projects Ext 01/02/2010 01/03/2010

Any suggestions greatefully received.

Many thanks
  #2  
Old March 24th, 2010, 05:49 PM posted to microsoft.public.excel.worksheet.functions
Glenn[_6_]
external usenet poster
 
Posts: 1,245
Default Sumproduct?

Hannah wrote:
Good Afternoon

Please could someone help....

I have a monster spreadsheet that tracks recruitment numbers and as part of
our monthly reporting i need to count various monthly stats

The information i need to summarise for each department is:

the number of internal candidates that were offered in each month
The number of external candidates that were offered in each month
the number of internal candidates that started in each month
The number of external candidates that started in each month,

Sample Data as follows:
Department Candiate type offer date Start date
Engineering Int 01/01/2010 01/02/2010
Supply Chain Int 31/12/2009 01/03/2010
Engineering Ext 01/01/2010 23/02/2010
Supply Chain Ext 15/01/2010 01/03/2010
Projects Ext 17/03/2010 01/04/2010
Projects Ext 01/02/2010 01/03/2010

Any suggestions greatefully received.

Many thanks



Try a PivotTable. They can be summarized by month.

If you are not familiar with PivotTables, look he

http://peltiertech.com/Excel/Pivots/pivotstart.htm
 




Thread Tools
Display Modes

Posting Rules
You may not post new threads
You may not post replies
You may not post attachments
You may not edit your posts

vB code is On
Smilies are On
[IMG] code is Off
HTML code is Off
Forum Jump


All times are GMT +1. The time now is 01:50 PM.


Powered by vBulletin® Version 3.6.4
Copyright ©2000 - 2024, Jelsoft Enterprises Ltd.
Copyright ©2004-2024 OfficeFrustration.
The comments are property of their posters.