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