Vlookup
 

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

Vlookup
 

Try this

=SUMIF(A1:A32,"EUR",B1:B32)

The formula will sum minus valus too.

Mike

"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

Vlookup
 

Lowan Chan;402905 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

Hi,
=sumif(a1:a10,"EUR",b1:b10) for 0 values
=sumproduct((a1:a10="usd)*(b1:b10<0)*b1:b10)


--
Pecoflyer

Cheers -

'Firefox 3.5' (http://www.mozilla.com/en-US/firefox/all-beta.html)
really IS fast !
------------------------------------------------------------------------
Pecoflyer's Profile: http://www.thecodecage.com/forumz/member.php?userid=14
View this thread: http://www.thecodecage.com/forumz/sh...d.php?t=112384

Vlookup
 

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

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

Mike

"Mike H" wrote:

Try this

=SUMIF(A1:A32,"EUR",B1:B32)

The formula will sum minus valus too.

Mike

"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

Vlookup
 

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

€žMike H€� ezt Ã*rta:

Try this

=SUMIF(A1:A32,"EUR",B1:B32)

The formula will sum minus valus too.

Mike

"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

Vlookup
 

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