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

Title	Group	Category	Earnings
Cash Associate	8	60	$1,900.00
Cash Associate	7	62	$3,200.00
Support	8	60	$4,000.00
Support II	1	60	$3,000.00
Cash Associate	2	65	$3,800.00
Specialist	2	60	$4,660.00
Specialist	8	60	$3,800.00
Specialist	8	60	$4,000.00
Support II	8	60	$5,000.00
Specialist	10	60	$3,900.00
Specialist	8	60	$900.00
Support I	8	60	$3,500.00
Cash Associate	5	60	$4,500.00
Support	4	60	$2,500.00
Cash Associate	8	62	$2,200.00

<TBODY>
</TBODY>

 

[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?