Averageifs + <> ???

[Maria5]

I definitely need help. Here's what I'm trying to do:
Average the Earnings if Category = 60, Group = 8, Title = Support, Support I and Support II (basically, all Titles EXCEPT Cash Associate and Specialist). The answer should be $4,166.67 but I don't know how to get a formula to give me the answer.

Please no VBA since I do not know it
[TABLE="width: 266"]
<TBODY>[TR]
[TD="class: xl63, width: 162, bgcolor: #dce6f1"]Title
[/TD]
[TD="class: xl63, width: 64, bgcolor: #dce6f1"]Group
[/TD]
[TD="class: xl63, width: 64, bgcolor: #dce6f1"]Category
[/TD]
[TD="class: xl64, width: 64, bgcolor: #dce6f1"]Earnings
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Cash Associate
[/TD]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="bgcolor: transparent, align: right"]60
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]$1,900.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Cash Associate
[/TD]
[TD="bgcolor: transparent, align: right"]7
[/TD]
[TD="bgcolor: transparent, align: right"]62
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]$3,200.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Support
[/TD]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="bgcolor: transparent, align: right"]60
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]$4,000.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Support II
[/TD]
[TD="bgcolor: transparent, align: right"]1
[/TD]
[TD="bgcolor: transparent, align: right"]60
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]$3,000.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Cash Associate
[/TD]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="bgcolor: transparent, align: right"]65
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]$3,800.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Specialist
[/TD]
[TD="bgcolor: transparent, align: right"]2
[/TD]
[TD="bgcolor: transparent, align: right"]60
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]$4,660.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Specialist
[/TD]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="bgcolor: transparent, align: right"]60
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]$3,800.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Specialist
[/TD]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="bgcolor: transparent, align: right"]60
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]$4,000.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Support II
[/TD]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="bgcolor: transparent, align: right"]60
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]$5,000.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Specialist
[/TD]
[TD="bgcolor: transparent, align: right"]10
[/TD]
[TD="bgcolor: transparent, align: right"]60
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]$3,900.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Specialist
[/TD]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="bgcolor: transparent, align: right"]60
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]$900.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Support I
[/TD]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="bgcolor: transparent, align: right"]60
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]$3,500.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Cash Associate
[/TD]
[TD="bgcolor: transparent, align: right"]5
[/TD]
[TD="bgcolor: transparent, align: right"]60
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]$4,500.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Support
[/TD]
[TD="bgcolor: transparent, align: right"]4
[/TD]
[TD="bgcolor: transparent, align: right"]60
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]$2,500.00
[/TD]
[/TR]
[TR]
[TD="bgcolor: transparent"]Cash Associate
[/TD]
[TD="bgcolor: transparent, align: right"]8
[/TD]
[TD="bgcolor: transparent, align: right"]62
[/TD]
[TD="class: xl65, bgcolor: transparent, align: right"]$2,200.00
[/TD]
[/TR]
</TBODY>[/TABLE]

 

[VBA Geek]

=AVERAGEIFS(D2:D16,C2:C16,60,B2:B16,8,A2:A16,"Support*")

 

[Jonmo1]

How about using "Support*" as the criteria?

=AVERAGEIFS(Earnings,Title,"Support*",Category,60,Group,8)

 

[Aladin Akyurek]

Try...

=AVERAGEIFS(D:D,A:A,"*support*",B:B,8,C:C,60)

 

[Maria5]

What if one of the titles that I wanted to included was Lead? So I would want to average all the earnings of Support, Support I, Support II and Lead and exclude the other 2?

 

[Maria5]

That's interesting regarding support*. I never knew to use the asterisk! Learned something new already

 

[Jonmo1]

In that case, I suggest a helper column..

If there are fewer to EXclude, than to INclude..
Try this in an available column, Say F

=OR(A1={"Cash Associate", "Specialist"})

Then use
=AVERAGEIFS(D:D,F:F,FALSE,B:B,8,C:C,60)

 

[Maria5]

Ah! Good idea! Thank you!!!

 

[Jonmo1]

You're welcome.

FYI, to change it to an INclusive instead of EXclusive,
Just change FALSE to TRUE in the Averageifs.

 

[Aladin Akyurek]

What if one of the titles that I wanted to included was Lead? So I would want to average all the earnings of Support, Support I, Support II and Lead and exclude the other 2?

What do you mean by Lead exactly?