You're welcome. Thanks for the feedback!

--
Biff
Microsoft Excel MVP


"Lidy693" wrote in message
...
Thanks Biff, i'm so relieved now that i can calculate these totals, much
appreciated
--
Lidy


"T. Valko" wrote:

Try this:

=SUMPRODUCT(--(A2:A6="Sales"),--(B2:B6="Staff Rude"),C2:C6)

Better to use cells to hold the criteria:

E1 = Sales
F1 = Staff Rude

=SUMPRODUCT(--(A2:A6=E1),--(B2:B6=F1),C2:C6)

Note that with SUMPRODUCT you can't use entire columns as range
references
unless you're using Excel 2007. And, if you are using Excel 2007 I'd use
this formula:

=SUMIFS(C:C,A:A,E1,B:B,F1)

--
Biff
Microsoft Excel MVP


"Lidy693" wrote in message
...
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