Vlookup

L

Lowan Chan

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.
 
M

Mike H

Perhaps I misunderstood and you only want to sum the negative values

=SUMPRODUCT((A1:A20="USD")*(B1:B20<0)*(B1:B20))

Mike
 
S

Stefi

For negative USD only:
=SUMPRODUCT(--(A1:A5="USD"),--(B1:B5<0),B1:B5)
Regards,
Stefi

„Mike H†ezt írta:
 
J

Jacob Skaria

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
 

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

Similar Threads

If statement for equivalent value of a range 4
Pivot Table with odd results 3
filter on currency number format 3
To get a sum for variant currency values 3
Extracting numbers from a cell 2
Median continued 12
how to totalize only column value from certain accounting -> Currencyformat 10
currency 4

Top