SUMIF WITH MULTIPLE CRITERIA?

K

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!
 
B

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

Bob Phillips

But the OP might not :)

--
HTH

Bob

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

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!
 

Ask a Question

Want to reply to this thread or ask your own question?

You'll need to choose a username for the site, which only take a couple of moments. After that, you can post your question and our members will help you out.

Ask a Question

Top