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