=SUMIF('Production Calendar'!D10:D104,"SMF",'Production
Calendar'!G10:G105)/COUNTIF('Production Calendar'!D10:D104,"SMF")

Using this formula I was able to get the average wage of all the SMF
employees but I need a formula that will give me all the SMF and Memco
employees average wage.

Thanks for the help guys



Production Calendar (sheet 1)

john doe Memco SMF $20
joe garcia AAS SMH $13
jessie nelson Memco SMF $10
david toms Memco SMM $ 9


Wage Summary (sheet 2)

average wage of a Memco, SMF employee formula on sheet 2


The answer would be $15


Therefore if someone is added to sheet 1 their wage would be calculated into
sheet 2's formula and therefore automatically updating sheet 2








"AAS" wrote:

I was not sure if original posts were kept up with, sorry about that. I have
been array-entering two different formulas but am not coming up with a number

=AVERAGE(IF(('Production Calendar'!C11:C105="Memco")*('Production
Calendar'!D11:D105="SMF"),'Production Calendar'!G11:G105))

=AVERAGE(IF('Production Calendar'!C11:C97="Memco",IF('Production
Calendar'!D11:D97="SMF",'Production Calendar'!G11:G97)))

Thanks alot for the advice.



"Max" wrote:

You never gave our responses a chance. Stick to your original thread

=AVERAGE(IF(('Production Calendar'!C11:C97="Memco")*('Production
Calendar'!D11:D97="SMF"),'Production Calendar'!G11:G97))

Your adaptation of the suggestion above seems ok.
But did you remember to "array-enter" it, as per my earlier line:
"..*Press CTRL+SHIFT+ENTER to confirm the formula"
--
Max
Singapore
http://savefile.com/projects/236895
xdemechanik
---