averaging from another page

[AAS]

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

 

[RagDyer]

One way:

=Sumif(B1:b5,"plumber",C1:C5)/Countif(B1:B5,"plumber)

 

[Bob Phillips]

=AVERAGE(IF(Sheet1!B1:B100="plumber",Sheet1!C1:C100))

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

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[AAS]

=AVERAGE(IF('Production Calendar'!D1197="SMF",'Production
Calendar'!G11:G97))

this is the exact formula i have been using. i do not know where it is going
wrong.


Production Calendar

John Doe SMF 10
Jerry Jones TC 12
Tom Tanner EC 15
Luis Rodriguez SMF 20
Joe Daniels EC 10


Wage Summary

average hourly wage rate for smf $15

 

[Bob Phillips]

Did you array enter it?

--
---
HTH

Bob


(there's no email, no snail mail, but somewhere should be gmail in my addy)

 

[AAS]

yea i did i just had to tweek it a little bit. Thanks for all the advice Bob.
Now I'm working on another problem