I am trying to average certain employees from worksheet 1 into a formula on
worksheet 2. I must be able to specify which employees to only average from.
If another person is added to worksheet 1 i would like worksheet 2 to also
portray the change.
example

worksheet 1
John Doe plumber 10
Jerry Jones technician 12
Tom Tanner electrician 15
Luis Rodriguez plumber 20
Joe Daniels electrician 10


worksheet 2
average wage rate for plumbers $15