A
AAS
Still not quite sure what is going wrong..
=AVERAGE(IF(('Production Calendar'!C11:C97="Memco")*('Production
Calendar'!D1197="SMF"),'Production Calendar'!G11:G97))
I'm trying this formula but its not working. I'm trying to average the wages
from column G11:G97 that are Memco column C11:C97 and SMF column D1197
Hi,
You can use the function DAVERAGE to get the average wage of Memco,SMF
employees. I have tried it and got the same result i.e. $15.
following is pasted in columns A to E
Name1 Name2 Deptt code Wage
john doe Memco SMF $20
joe garcia $13
jessie nelson Memco SMF $10
david toms Memco SMM $9
Following criteria is given in column H to L
Name1 Name1 Deptt code Wage
Memco SMF
Now you can use the following formulae:-
=DAVERAGE(A1:E5,E1,H1:L2)
and it will give you the desired result $15.
Please let me know if this helps.
Thanks
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
In Sheet2, array-enter* something like this:
=AVERAGE(IF((Sheet1!B2:B5="Memco")*(Sheet1!C2:C5="SMF"),Sheet1!D25))
*Press CTRL+SHIFT+ENTER to confirm the formula
Adapt the ranges to suit
=AVERAGE(IF(('Production Calendar'!C11:C97="Memco")*('Production
Calendar'!D1197="SMF"),'Production Calendar'!G11:G97))
I'm trying this formula but its not working. I'm trying to average the wages
from column G11:G97 that are Memco column C11:C97 and SMF column D1197
Hi,
You can use the function DAVERAGE to get the average wage of Memco,SMF
employees. I have tried it and got the same result i.e. $15.
following is pasted in columns A to E
Name1 Name2 Deptt code Wage
john doe Memco SMF $20
joe garcia $13
jessie nelson Memco SMF $10
david toms Memco SMM $9
Following criteria is given in column H to L
Name1 Name1 Deptt code Wage
Memco SMF
Now you can use the following formulae:-
=DAVERAGE(A1:E5,E1,H1:L2)
and it will give you the desired result $15.
Please let me know if this helps.
Thanks
--
Dilip Kumar Pandey
MBA, BCA, B.Com(Hons.)
(e-mail address removed)
(e-mail address removed)
New Delhi, India
In Sheet2, array-enter* something like this:
=AVERAGE(IF((Sheet1!B2:B5="Memco")*(Sheet1!C2:C5="SMF"),Sheet1!D25))
*Press CTRL+SHIFT+ENTER to confirm the formula
Adapt the ranges to suit