Hi there, need to sum up totals in a column, with 2 or more criteria:

eg:
A B C
USD LONG 10
EUR SHORT 10
USD LONG 10
USD SHORT

need to SUMIF if Column A is USD AND Column B is LONG..in this case to
return 20
also maybe other columns with additional criteria...can it be extended?

thanks!

=SUMPRODUCT(--(A2:A20="USD"),--(B2:B200="LONG),C2:C200)

--
HTH

Bob

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

"kahuna" wrote in message
...
Hi there, need to sum up totals in a column, with 2 or more criteria:

eg:
A B C
USD LONG 10
EUR SHORT 10
USD LONG 10
USD SHORT

need to SUMIF if Column A is USD AND Column B is LONG..in this case to
return 20
also maybe other columns with additional criteria...can it be extended?

thanks!

that A2:A20 should be A2:A200
(but you knew that!)

"Bob Phillips" wrote in message
...
=SUMPRODUCT(--(A2:A20="USD"),--(B2:B200="LONG),C2:C200)

--
HTH

Bob

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

"kahuna" wrote in message
...
Hi there, need to sum up totals in a column, with 2 or more criteria:

eg:
A B C
USD LONG 10
EUR SHORT 10
USD LONG 10
USD SHORT

need to SUMIF if Column A is USD AND Column B is LONG..in this case to
return 20
also maybe other columns with additional criteria...can it be extended?

thanks!

But the OP might not :-)

--
HTH

Bob

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

"Bob Umlas" wrote in message
...
that A2:A20 should be A2:A200
(but you knew that!)

"Bob Phillips" wrote in message
...
=SUMPRODUCT(--(A2:A20="USD"),--(B2:B200="LONG),C2:C200)

--
HTH

Bob

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

"kahuna" wrote in message
...
Hi there, need to sum up totals in a column, with 2 or more criteria:

eg:
A B C
USD LONG 10
EUR SHORT 10
USD LONG 10
USD SHORT

need to SUMIF if Column A is USD AND Column B is LONG..in this case to
return 20
also maybe other columns with additional criteria...can it be extended?

thanks!

fantastic thanks, i don`t suppose you could satisfy my curiosity and show how
its doing that? is the -- making the paramenters negative so when they
multiply you just get 1 to multiply the last column by? thanks again!

"Bob Phillips" wrote:

But the OP might not :-)

--
HTH

Bob

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

"Bob Umlas" wrote in message
...
that A2:A20 should be A2:A200
(but you knew that!)

"Bob Phillips" wrote in message
...
=SUMPRODUCT(--(A2:A20="USD"),--(B2:B200="LONG),C2:C200)

--
HTH

Bob

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

"kahuna" wrote in message
...
Hi there, need to sum up totals in a column, with 2 or more criteria:

eg:
A B C
USD LONG 10
EUR SHORT 10
USD LONG 10
USD SHORT

need to SUMIF if Column A is USD AND Column B is LONG..in this case to
return 20
also maybe other columns with additional criteria...can it be extended?

thanks!

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)

"kahuna" wrote in message
...
fantastic thanks, i don`t suppose you could satisfy my curiosity and show
how
its doing that? is the -- making the paramenters negative so when they
multiply you just get 1 to multiply the last column by? thanks again!

"Bob Phillips" wrote:

But the OP might not :-)

--
HTH

Bob

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

"Bob Umlas" wrote in message
...
that A2:A20 should be A2:A200
(but you knew that!)

"Bob Phillips" wrote in message
...
=SUMPRODUCT(--(A2:A20="USD"),--(B2:B200="LONG),C2:C200)

--
HTH

Bob

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

"kahuna" wrote in message
...
Hi there, need to sum up totals in a column, with 2 or more criteria:

eg:
A B C
USD LONG 10
EUR SHORT 10
USD LONG 10
USD SHORT

need to SUMIF if Column A is USD AND Column B is LONG..in this case
to
return 20
also maybe other columns with additional criteria...can it be
extended?

thanks!