Hi,
I need a solution for the spreadsheet attached. In column L I have a sumif function that will provide the sum of notional for a particular day. What I need this function to do is to sum the absolute value of the notional on any given day, however, if the counterparty name (column I) and the index name (column H) match then net these two amounts together prior to taking the absolute value of the notionals.
Please let me know what other information i can provide to make this more clear.
"forum.ozgrid.com/index.php?attachment/52699/al"
Thank you