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!!!

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!!!

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!!!

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!!!