Formulas!?!?!????

J

jbressma

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

Bob Phillips

See other post.

--

HTH

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

Biff

Hi!

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

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

Biff
 
Top