averaging from another page
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
|