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