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)

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)

=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10="B"),C1:C10)


--
Regards,

Peo Sjoblom


"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)

=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),C1:C10

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"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)

very useful!
what is the -- function for??

"Bob Phillips" wrote:

=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),C1:C10

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"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)

See http://www.xldynamic.com/source/xld.SUMPRODUCT.html for a detailed
explanation.

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Harry Seymour" wrote in message
...
very useful!
what is the -- function for??

"Bob Phillips" wrote:

=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),C1:C10

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"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)

I hope that you noticed I missed a trailing bracket

=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),C1:C10)
--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Harry Seymour" wrote in message
...
very useful!
what is the -- function for??

"Bob Phillips" wrote:

=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),C1:C10

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"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)

I saw that, but Excel would have corrected it.


"Bob Phillips" wrote in message
...
I hope that you noticed I missed a trailing bracket

=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),C1:C10)
--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Harry Seymour" wrote in message
...
very useful!
what is the -- function for??

"Bob Phillips" wrote:

=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),C1:C10

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"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)

got it!
this is a really good function, and thanks for pointing me towards that
information website, can see it coming in handy.

I thought my excel skills were fairly good, but this is described as a basic
function!

Thanks all
Harry

"PCLIVE" wrote:

I saw that, but Excel would have corrected it.


"Bob Phillips" wrote in message
...
I hope that you noticed I missed a trailing bracket

=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),C1:C10)
--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Harry Seymour" wrote in message
...
very useful!
what is the -- function for??

"Bob Phillips" wrote:

=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),C1:C10

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"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)

It is basic in its basic form, but what you see there is stretching it well
beyond the basic in many instances,

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my addy)

"Harry Seymour" wrote in message
...
got it!
this is a really good function, and thanks for pointing me towards that
information website, can see it coming in handy.

I thought my excel skills were fairly good, but this is described as a
basic
function!

Thanks all
Harry

"PCLIVE" wrote:

I saw that, but Excel would have corrected it.


"Bob Phillips" wrote in message
...
I hope that you noticed I missed a trailing bracket

=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),C1:C10)
--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"Harry Seymour" wrote in
message
...
very useful!
what is the -- function for??

"Bob Phillips" wrote:

=SUMPRODUCT(--(A1:A10="Jon"),--(B1:B10=B"),C1:C10

--
HTH

Bob

(there's no email, no snail mail, but somewhere should be gmail in my
addy)

"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)