SUMIF WITH MULTIPLE CRITERIA?

[kahuna]

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!

 

[Bob Phillips]

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

 

[Bob Umlas]

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

 

[Bob Phillips]

But the OP might not

--
HTH

Bob

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

 

[kahuna]

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]

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)