Try this:

=SUMPRODUCT(--(A$1:A$10="Jon"),--(B$1:B$10="B"),C$1:C$10)

HTH,
Paul



"Harry Seymour" <Harry wrote in message
...
How can I sum values in my third column by specifying conditions in my
first
two?

e.g. Column A has values "Jon", "Max", "Mary", "Tom"
Column B has values "A" and "B".
Column C has values for each.

I need to sum C values where column A shows "Jon" and column B shows "B".
I've tried =sumif(AND(A1:A10, "Jon"),(B1:B10, "B"), C1:C10) with no luck.
the usual sumif should have the format =sumif(range to be assessed,
Criteria, range to be summed)