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
Created attachment 184963 [details] screenshot screenshot
The screenshot makes it rather tricky to check, e.g., contents of Log.A530, to see if it contains any time in addition to the date. And indeed, the value of '2023-01-26' is different from '2023-01-26 01:15', and SUMIF, which only has one specific value (macroLvl.B30) as its criterion, would match one, but not the other, despite the *look* of both would be the same when using a 'DD/MM/YY' format string. But it could be something different, and as said, screenshots are not the best thing to analyze problems.
(In reply to Mike Kaganski from comment #2) > ... contents of Log.A530, ... Indeed, "contents of Log.B530" was meant.
please attach test file. Thank you.
Created attachment 184977 [details] test spreadsheet testfile
Created attachment 184978 [details] screenshot There is no additional parameters to the range lookup column that I am aware of.
[Automated Action] NeedInfo-To-Unconfirmed
(In reply to Roberto from comment #5) And what is the expected result? You didn't specify what you expect. Assuming that you expect in macroLvl.C3:C4 the same values as in Log.E25 and Log.E50: In the attached document, cell B41 has "01/25/23", and corresponding amount is 335.
You are correct. B41 should be 1/26/23. I don't see a resolution flag for "user error" or I'd add it. My sincere apologies.