averageif with 2 other criteria
thank you sir for your time and effort
"Sean Timmons" wrote:
It would give the mean average, which is what AVERAGe in Excel provides. You
are adding together the total of ages, then dividing by the number of people.
"v1rt8" wrote:
would this give me the avg age?
"Sean Timmons" wrote:
=SUMIF(r3:r1357,"active",q3:q1357)/countif(r3:r1357,"active")
Then,
=(SUMIF(r3:r1357,"active",q3:q1357)+SUMIF(r3:r1357 ,"mgt",q3:q1357))/(countif(r3:r1357,"active")+countif(r3:r1357,"mgt" ))
"v1rt8" wrote:
"v1rt8" wrote:
Need some help with an averageif calc.
setup is as follows:
q3:q1357 contains ages
r3:r1357 contains text (active), (MGT), (others)
so averageif q3:q1357 active and mgt in r3:r1357
so averageif q3:q1357 active in r3:r1357
looked at other questions in here and cannot find anything close
thanks in advance
|