[Libreoffice-bugs] [Bug 134234] FILEOPEN: SUM formulas are broken

[bugzilla-daemon at bugs.documentfoundation.org]

https://bugs.documentfoundation.org/show_bug.cgi?id=134234

--- Comment #4 from Joel Madero <jmadero.dev at gmail.com> ---
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.

-- 
You are receiving this mail because:
You are the assignee for the bug.
-------------- next part --------------
An HTML attachment was scrubbed...
URL: <https://lists.freedesktop.org/archives/libreoffice-bugs/attachments/20200625/68f40760/attachment.htm>