Formulas
 

I am creating a spreadsheet that tracks our employees, new hires, and
terminations. I have raw data that includes NAME, OFFICE (city), START
DATE, TERM DATE.

Is there a way to create a table with statistics from the above data? For
instance, how would I count all active employees in Atlanta. How would I
could all 2005 hires for atlanta? I am thinking its something to do with
either COUNTIF or SUMPRODUCT but I am not that great with Excel formulas that
include dates....

You could also do this with a PIVOT table.

http://www.cpearson.com/excel/pivots.htm


"jbressma" wrote:

I am creating a spreadsheet that tracks our employees, new hires, and
terminations. I have raw data that includes NAME, OFFICE (city), START
DATE, TERM DATE.

Is there a way to create a table with statistics from the above data? For
instance, how would I count all active employees in Atlanta. How would I
could all 2005 hires for atlanta? I am thinking its something to do with
either COUNTIF or SUMPRODUCT but I am not that great with Excel formulas that
include dates....