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 43:r1357
so averageif

looked at other questions in here and cannot find anything close
thanks in advance