Hi
I have the following data:

A B C
Team Complaint Type Action Required
Sales Staff Rude 1
Production Late Order 1
Sales Late Order 1
Accounts Staff Rude 1
Sales Staff Rude 1

I would like to be able to sum the action required (column C) when the team
(column A) is "Sales" and the complaint type (column B) is "Staff Rude", the
answer should be 2. The formula I am working with is:
=sumif(a:b,"sales" "staff rude",c:c)

But I keep getting error messages - can anyone help?

thanks Lidy