Are you using Excel 2007?

so averageif q3:q1357 active and mgt in r3:r1357
so averageif q3:q1357 active in r3:r1357

Are those 2 separate requests?

Get the average age if column R contains either active *or* mgt.

Get the average age if column R contains active.


--
Biff
Microsoft Excel MVP


"v1rt8" wrote in message
...


"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