|
Is it possible to do that using excel formulas ?
Hi All,
I'm working an a small macro to make my daily work easier Unfortunately I'm not good enough in excel to make it 100% by myself That's why I would really much appreciate your help on this ;-) I've attached the file in this post. Here is the problem : Below are the datas from the sheet "Estim - FX contracts by Fund" SELL JPY 496.000,00 BUY USD 16/07/2004 SELL USD 15.234,59 BUY EUR 19/07/2004 BUY EUR -8.711,74 SELL USD 19/07/2004 SELL USD 630.909,49 BUY EUR 19/07/2004 SELL CHF 136,78 BUY EUR 19/07/2004 BUY USD -11.563,43 SELL JPY 16/07/2004 BUY USD -10.168,00 SELL JPY 16/07/2004 BUY USD -398,02 SELL JPY 20/07/2004 Here are the results from the sheet I would like to be generate automaticly in the sheet "Estim -Aggregate FX contracts". It's in fac a summary of the above datas by currency and same value date. SELL JPY 496.000,0 BUY USD 16/07/2004 SELL USD 646.144,08 BUY EUR 19/07/2004 SELL CHF 136,78 BUY EUR 19/07/2004 BUY USD -21.731,43 SELL JPY 16/07/2004 BUY USD -398,02 SELL JPY 20/07/2004 BUY EUR -8.711,74 SELL USD 19/07/2004 For instance 646.144,08 is the sum of those 2 lines : SELL USD 15.234,59 BUY EUR 19/07/2004 SELL USD 630.909,49 BUY EUR 19/07/2004 Does anyone has an idea how I could do that ? I don't think tha sumprod would work in that case. Would it ? Thank you very much in advance, Gre Attachment filename: gregsmacro.zip Download attachment: http://www.excelforum.com/attachment.php?postid=62035 -- Message posted from http://www.ExcelForum.com |
Is it possible to do that using excel formulas ?
If the information from a row is separated into different columns for
easy identification, then SUMPRODUCT would probably work just fine. For Example =SUMPRODUCT((A1:A10="SELL USD")*(C1:C10="BUY EUR")*(D1:D10=DATEVALUE("19/07/2004")),B1:B10) Jerry Grek < wrote: Hi All, I'm working an a small macro to make my daily work easier. Unfortunately I'm not good enough in excel to make it 100% by myself. That's why I would really much appreciate your help on this ;-) I've attached the file in this post. Here is the problem : Below are the datas from the sheet "Estim - FX contracts by Fund" SELL JPY 496.000,00 BUY USD 16/07/2004 SELL USD 15.234,59 BUY EUR 19/07/2004 BUY EUR -8.711,74 SELL USD 19/07/2004 SELL USD 630.909,49 BUY EUR 19/07/2004 SELL CHF 136,78 BUY EUR 19/07/2004 BUY USD -11.563,43 SELL JPY 16/07/2004 BUY USD -10.168,00 SELL JPY 16/07/2004 BUY USD -398,02 SELL JPY 20/07/2004 Here are the results from the sheet I would like to be generated automaticly in the sheet "Estim -Aggregate FX contracts". It's in fact a summary of the above datas by currency and same value date. SELL JPY 496.000,0 BUY USD 16/07/2004 SELL USD 646.144,08 BUY EUR 19/07/2004 SELL CHF 136,78 BUY EUR 19/07/2004 BUY USD -21.731,43 SELL JPY 16/07/2004 BUY USD -398,02 SELL JPY 20/07/2004 BUY EUR -8.711,74 SELL USD 19/07/2004 For instance 646.144,08 is the sum of those 2 lines : SELL USD 15.234,59 BUY EUR 19/07/2004 SELL USD 630.909,49 BUY EUR 19/07/2004 Does anyone has an idea how I could do that ? I don't think that sumprod would work in that case. Would it ? Thank you very much in advance, Greg Attachment filename: gregsmacro.zip Download attachment: http://www.excelforum.com/attachment.php?postid=620353 --- Message posted from http://www.ExcelForum.com/ |
| All times are GMT +1. The time now is 12:13 PM. |
Powered by vBulletin® Copyright ©2000 - 2025, Jelsoft Enterprises Ltd.
ExcelBanter.com