| Home |
| Search |
| Today's Posts |
|
#1
Posted to microsoft.public.excel.misc
|
|||
|
|||
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 |
|
#2
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#3
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#4
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#5
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
|
#6
Posted to microsoft.public.excel.misc
|
|||
|
|||
|
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 |
| Reply |
| Thread Tools | Search this Thread |
| Display Modes | |
|
|
Similar Threads
|
||||
| Thread | Forum | |||
| VLookUp - Does the VLookUp return the exact information? | Excel Worksheet Functions | |||
| Vlookup in vlookup - taking the result as array name | Excel Worksheet Functions | |||
| Combine VLOOKUP and IF function so #NA isn't returned as a value from VLOOKUP | Excel Discussion (Misc queries) | |||
| Vlookup -=VLOOKUP(F9,LookUp1!$A$2:$B$1504,2,FALSE) | New Users to Excel | |||
| Vlookup info being used without vlookup table attached? | Excel Worksheet Functions | |||
Linear Mode
