Hi Lowan

1. How can I sum up for EUR and USD?

=SUMPRODUCT(--ISNUMBER(MATCH(A2:A10,{"USD","EUR"},0)),B2:B10)

2. How can I sum up for USD's minus number?

=SUMPRODUCT(--(A2:A10="USD"),--(B2:B10<0),B2:B10)

If this post helps click Yes
---------------
Jacob Skaria


"Lowan Chan" wrote:

I hav another question:

Column A Column B
EUR 79
USD 49
EUR -23
USD -15
USD -10

How can I sum up for EUR and USD? and how can I sum up for USD's minus
number?

Thanks a lot.
--
Lowan