| Summary: | SUMPRODUCT function treat empty cells in different ways (1 instead of 0), as the order of column vectors are reversed | ||
|---|---|---|---|
| Product: | LibreOffice | Reporter: | Laszlo Valy <laszlovaly> |
| Component: | Calc | Assignee: | Not Assigned <libreoffice-bugs> |
| Status: | RESOLVED DUPLICATE | ||
| Severity: | normal | CC: | laszlovaly, miguelangelrv |
| Priority: | medium | ||
| Version: | 4.2.0.4 release | ||
| Hardware: | x86-64 (AMD64) | ||
| OS: | Windows (All) | ||
| Whiteboard: | |||
| Crash report or crash signature: | Regression By: | ||
| Attachments: | Asymetry in SUMPRODUCT | ||
Created attachment 94597 [details] Asymetry in SUMPRODUCT SUMPRODUCT function treat empty cells as 1 when the arrays in the calculations in the argument are placed in reverse order, but treat empty cells as 0 when the arrays in the calculations in the argument are placed in the usual increasing order. For example: Increasing order: SUMPRODUCT($A3:$A11;H3:H11) treat empty cells as 0 in both vectors Reverse order: SUMPRODUCT(H3:H11;$A3:$A11) treat empty cells as 1 in the H3:H11 vector but not in the $A3:$A11 vector