Formulas!?!??

  • Thread starter Thread starter Guest
  • Start date Start date
G

Guest

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!!!!
 
=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)
 
You must log in or register to reply here.

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Similar Threads

Formulas!?!?!???? 3
Formula to another forumula? 10
formula 1
formula/s 2
How do I create a small array from a larger one? 3
Conditional Sum 6
sum and count text and numbers same column 1
tenure 14

Back
Top