Home |
Search |
Today's Posts |
#1
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#2
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#3
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#4
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#5
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
#6
Posted to microsoft.public.excel.worksheet.functions
|
|||
|
|||
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 |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
If formula with two conditions to meet | Excel Worksheet Functions | |||
taking conditions from one spreadsheet to another | Excel Worksheet Functions | |||
calculate total number of items that meet 2 over multiple sheets | Excel Worksheet Functions | |||
Array to meet conditions | Excel Worksheet Functions | |||
How do I get the total number of items that meet 2 criteria in Exc | Excel Worksheet Functions |