<html> <head> <base href="https://bugs.documentfoundation.org/"> </head> <body> <div> <a class="bz_bug_link bz_status_NEW " title="NEW - FILEOPEN: SUM formulas are broken" href="https://bugs.documentfoundation.org/show_bug.cgi?id=134234#c4">Comment # 4</a> on <a class="bz_bug_link bz_status_NEW " title="NEW - FILEOPEN: SUM formulas are broken" href="https://bugs.documentfoundation.org/show_bug.cgi?id=134234">bug 134234</a> from <a class="email" href="mailto:jmadero.dev@gmail.com" title="Joel Madero <jmadero.dev@gmail.com>"> Joel Madero</a> <pre>Xisco - I'm not sure the title accurately gets the issue (SUM). Look at column E on "Current Portfolio Analysis". There isn't a SUM value there. The formula is: =SUMPRODUCT(--($'Trade Ledger'.$C$2:$'Trade Ledger'.$C$10000=A2),--($'Trade Ledger'.$B$2:$'Trade Ledger'.$B$10000="Buy"),$'Trade Ledger'.$I$2:$'Trade Ledger'.$I$10000,$'Trade Ledger'.$E$2:$'Trade Ledger'.$E$10000)/SUMIFS($'Trade Ledger'.$E$2:$'Trade Ledger'.$E$10000,$'Trade Ledger'.$C$2:$'Trade Ledger'.$C$10000,A2,$'Trade Ledger'.$B$2:$'Trade Ledger'.$B$10000,"Buy") There is SUMPRODUCT and SUMIFS but no just SUM. Just wanted to point it out. Updated my git pull today and notice that the problem is still there. Going to revert that patch from Noel to confirm that the issue goes away.</pre> </div> <hr> You are receiving this mail because: <ul> <li>You are the assignee for the bug.</li> </ul> </body> </html>