https://bugs.documentfoundation.org/show_bug.cgi?id=153249
Bug ID: 153249
Summary: Sumif appears to give wrong result
Product: LibreOffice
Version: 7.4.3.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Am unable to reconcile a sumif result to result seen when range is manually
filtered and summed.
Steps to Reproduce:
1. Create table (pivot by date) in sheet 1
2. In sheet 2 create a sumif with date as criteria (cell reference to cell with
same date, in this instance).
Actual Results:
sumif total < manual sum
Expected Results:
sumif total = manual sum
Reproducible: Always
User Profile Reset: No
Additional Info:
[Information automatically included from LibreOffice]
Locale: en-US
Module: SpreadsheetDocument
[Information guessed from browser]
OS: Windows (All)
OS is 64bit: no
Version: 7.4.5.1 (x64) / LibreOffice Community
Build ID: 9c0871452b3918c1019dde9bfac75448afc4b57f
CPU threads: 24; OS: Windows 10.0 Build 22621; UI render: Skia/Raster; VCL: win
Locale: en-US (en_US); UI: en-US
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
