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

One way:

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

RD

---------------------------------------------------------------------------
Please keep all correspondence within the NewsGroup, so all may benefit !
---------------------------------------------------------------------------

"AAS" wrote in message
...
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

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

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" wrote in message
...
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

=AVERAGE(IF('Production Calendar'!D11:D97="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









"AAS" wrote:

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

Did you array enter it?

--
---
HTH

Bob


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



"AAS" wrote in message
...
=AVERAGE(IF('Production Calendar'!D11:D97="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









"AAS" wrote:

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

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

"Bob Phillips" wrote:

Did you array enter it?

--
---
HTH

Bob


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



"AAS" wrote in message
...
=AVERAGE(IF('Production Calendar'!D11:D97="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









"AAS" wrote:

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