G
Guest
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....
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....