sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A"
 

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)

sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A"
 

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)

sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A"
 

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

sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,"A"
 

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

sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,
 

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)

sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,
 

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)

sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,
 

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)

sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,
 

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)

sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,
 

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)

sumif for multi conditions. i.e sumif(A1:A10,"Jon" and B1:B10,
 

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)