Formulas!?!?!????

[Guest]

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

 

[Bob Phillips]

See other post.

--

HTH

RP
(remove nothere from the email address if mailing direct)

 

[Biff]

Hi!

Entered as an array using the key combo of CTRL,SHIFT,ENTER:

=AVERAGE(IF(Column_B="active",Column_D))

Biff

 

[Guest]

THANKS BOB & BIFF!