Sumproduct?


H

Hannah

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
 
Ad

Advertisements

G

Glenn

Hannah said:
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 here:

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

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads


Top