Formulas!?!??

J

jbressma

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

Bob Phillips

=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)
 
Top