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