Taking a total number of employees that meet certain conditions
 

I am trying to calculate how many employees have been employed from their
start date to today's date (for example). Then, they need to be categorized
by total number of employees that have worked more than 365 days, 730 days,
etc.

So far, I have the following list:

Today's Date: 09/09/2008

Name: Start Date: Number of dates employed:
John 11/05/2007 309
Jane 07/09/2007 428
Jacob 07/09/2007 428
Joel 07/10/2006 792
Janet 07/10/2006 792
Joey 07/10/2006 792

Total number of employees is 6

The solution should show:

# employed 365 days is 5
# employed 730 days is 3

Taking a total number of employees that meet certain conditions
 

=COUNTIF(C2:C7,"365")

=COUNTIF(C2:C7,"730")

"sanedracnehpets" wrote:

I am trying to calculate how many employees have been employed from their
start date to today's date (for example). Then, they need to be categorized
by total number of employees that have worked more than 365 days, 730 days,
etc.

So far, I have the following list:

Today's Date: 09/09/2008

Name: Start Date: Number of dates employed:
John 11/05/2007 309
Jane 07/09/2007 428
Jacob 07/09/2007 428
Joel 07/10/2006 792
Janet 07/10/2006 792
Joey 07/10/2006 792

Total number of employees is 6

The solution should show:

# employed 365 days is 5
# employed 730 days is 3

Taking a total number of employees that meet certain conditions
 

In cells E8 thru E9 enter (or elsewhere):
=COUNTIF(C:C,"" & 365)
=COUNTIF(C:C,"" & 730)

--
Gary''s Student - gsnu200803

Taking a total number of employees that meet certain conditions
 

=SUMPRODUCT(--((B2:B7-TODAY())365))

without the helper column, or

=COUNTIF(C:C,"365")

with

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"sanedracnehpets" wrote in
message ...
I am trying to calculate how many employees have been employed from their
start date to today's date (for example). Then, they need to be
categorized
by total number of employees that have worked more than 365 days, 730
days,
etc.

So far, I have the following list:

Today's Date: 09/09/2008

Name: Start Date: Number of dates employed:
John 11/05/2007 309
Jane 07/09/2007 428
Jacob 07/09/2007 428
Joel 07/10/2006 792
Janet 07/10/2006 792
Joey 07/10/2006 792

Total number of employees is 6

The solution should show:

# employed 365 days is 5
# employed 730 days is 3

Taking a total number of employees that meet certain condition
 

Thank you very much

Is there a way to filter to not include certain people? i.e.

Today's Date: 09/09/2008
A B C D
1 Name: Start Date: Number of dates employed: Status:
2 John 11/05/2007 309 Employed
3 Jane 07/09/2007 428 Employed
4 Jacob 07/09/2007 428 No longer Employed
5 Joel 07/10/2006 792 No longer Employed
6 Janet 07/10/2006 792 Employed
7 Joey 07/10/2006 792 Employed

Total number of employees is 6

The solution should now show:

# employed 365 days is 3
# employed 730 days is 2

Taking a total number of employees that meet certain conditions
 

You may als want to read on the Database functions of Excel.

--
Regards,

Ashsih Mathur
Microsoft Excel MVP
www.ashishmathur.com

"sanedracnehpets" wrote in
message ...
I am trying to calculate how many employees have been employed from their
start date to today's date (for example). Then, they need to be
categorized
by total number of employees that have worked more than 365 days, 730
days,
etc.

So far, I have the following list:

Today's Date: 09/09/2008

Name: Start Date: Number of dates employed:
John 11/05/2007 309
Jane 07/09/2007 428
Jacob 07/09/2007 428
Joel 07/10/2006 792
Janet 07/10/2006 792
Joey 07/10/2006 792

Total number of employees is 6

The solution should show:

# employed 365 days is 5
# employed 730 days is 3