averageif with 2 other criteria
"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
|