HELP Averageifs multiples

[kenzotokyo]

Hi Guys I am new here, and I will introduce my self properly soon.

I have a problem.
here is an example
(Column A) (Column B) (Column C) (Column D) (Column E)
LAST_NAME FIRST_NAME GENDER AGE Job Role
James wo m 20 DR
B ho m 30 Junior DR
C chow F 10 Junior DR
D lee F 10 Junior DR

Average the Age

Okay so I know how to averageIf, for one criteria. EG. =Averageif(D:D,C:C,"M",E:E,"DR")

---

Now the problem is that I want an Averageifs on Junior Dr(s), how do I write it??
help please

[AlanY]

try this

=AVERAGEIFS(D1:D4,E1:E4,"Junior*")

[kenzotokyo]

Im Sorry I for got to say I need all the M (Male) Junior DR
so there is two criteria
Im really confuse, I have used filter but I need to learn formulars

Thanks Alan for the reply

[AlanY]

you can add another criteria to the averageifs();

=AVERAGEIFS(D1:D4,E1:E4,"Junior*",C1:C4,"m")

[kenzotokyo]

thanks Alan, your a star

[AlanY]

you're welcome

[kenzotokyo]

HI
In my work I need average age of all M in the different job description

So I need all M (male) average age of Junior Dr, Dr, Nurses etc

[AlanY]

HI
In my work I need average age of all M in the different job description

So I need all M (male) average age of Junior Dr, Dr, Nurses etc

you can add another criteria to the averageifs();

=AVERAGEIFS(D1:D4,E1:E4,"Junior*",C1:C4,"m")

you just need to change the RED to Dr, Nurced etc