=AVERAGE(IF(C2:C1000="active",E2:E1000)

which is an array formula, so commit with Ctrl-Shift-Enter

--

HTH

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


"jbressma" wrote in message
...
I have an Excel spreadsheet that lists all employees. Column C is
headed
"status" (active/terminated) and Column E is headed "tenure" (numerical
value
of years w/company).

I would like to calculate the average tenure for all active
employees.....do
you know if this is possible and if so how I can do it? Thanks!!!!