Home |
Search |
Today's Posts |
#1
|
|||
|
|||
Formulas!?!?!????
I have an excel spreadsheet that contains employee information. Column B is
headed "Status" and contains either an "Active" or "Terminated" value. Column D is headed "Tenure" and contains the numerical value of how long they have worked with the company (i.e. 4.5 years). I would like to know how to calculate the average tenure of all "Active" employees. Any help is appreciated!!! |
#2
|
|||
|
|||
Formulas!?!?!????
See other post.
-- HTH RP (remove nothere from the email address if mailing direct) "jbressma" wrote in message ... I have an excel spreadsheet that contains employee information. Column B is headed "Status" and contains either an "Active" or "Terminated" value. Column D is headed "Tenure" and contains the numerical value of how long they have worked with the company (i.e. 4.5 years). I would like to know how to calculate the average tenure of all "Active" employees. Any help is appreciated!!! |
#3
|
|||
|
|||
Formulas!?!?!????
Hi!
Entered as an array using the key combo of CTRL,SHIFT,ENTER: =AVERAGE(IF(Column_B="active",Column_D)) Biff "jbressma" wrote in message ... I have an excel spreadsheet that contains employee information. Column B is headed "Status" and contains either an "Active" or "Terminated" value. Column D is headed "Tenure" and contains the numerical value of how long they have worked with the company (i.e. 4.5 years). I would like to know how to calculate the average tenure of all "Active" employees. Any help is appreciated!!! |
#4
|
|||
|
|||
Formulas!?!?!????
THANKS BOB & BIFF!
"jbressma" wrote: I have an excel spreadsheet that contains employee information. Column B is headed "Status" and contains either an "Active" or "Terminated" value. Column D is headed "Tenure" and contains the numerical value of how long they have worked with the company (i.e. 4.5 years). I would like to know how to calculate the average tenure of all "Active" employees. Any help is appreciated!!! |
Reply |
Thread Tools | Search this Thread |
Display Modes | |
|
|
Similar Threads | ||||
Thread | Forum | |||
Array Formulas take waaaay too long... | Excel Worksheet Functions | |||
Problem with named formula's | Excel Worksheet Functions | |||
How to make Excel run limited number of formulas on a given worksh | Excel Discussion (Misc queries) | |||
Way to make Excel only run certain formulas on a worksheet? | Excel Discussion (Misc queries) | |||
calculating formulas for all workbooks in a folder | Excel Worksheet Functions |