linking different worksheets in a workbook for a formula

  • Thread starter Thread starter AAS
  • Start date Start date
A

AAS

two excel worksheets. Worksheet 1 includes all of the employees along with
their hourly rate. These employees can also be filtered according to their
job position. In worksheet 2 the company is broken down into different job
positions and the quantity of people in each job position..it also has their
average hourly wage. I want to link the two worksheets therefore if you add
an employee to worksheet 1, then worksheet 2's formula will also include the
newly added employee's hourly wage into the average on worksheet 2.
Thanks for any help you might have.
 
You can use COUNTIF to count the number of people in a certain job
position, such as:

=COUNTIF(Sheet1!C:C,"supervisor")

To get the average you can use:

=SUMIF(Sheet1!C:C,"supervisor",Sheet1!B:B)/COUNTIF(Sheet1!
C:C,"supervisor")

Assumes pay rate is in column B and job position is in column C in
Sheet1. The word supervisor can be replaced by acell reference on
Sheet2 which contains the job position, and then the formula can be
copied down.

Hope this helps.

Pete
 
Back
Top