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

            Bug ID: 154173
           Summary: =SUMIF(A$1:A$240,H1,B$1:B$240) does not work half the
                    time
           Product: LibreOffice
           Version: 7.5.1.2 release
          Hardware: x86-64 (AMD64)
                OS: Windows (All)
            Status: UNCONFIRMED
          Severity: normal
          Priority: medium
         Component: LibreOffice
          Assignee: [email protected]
          Reporter: [email protected]

Description:
=SUMIF(A$1:A$240,H1,B$1:B$240) does not work half the time

sumif fails to match content of H1 in equation above in A$1:A$240, although
exists.

Actual Results:
results in 0

Expected Results:
a number > 0


Reproducible: Sometimes


User Profile Reset: No

Additional Info:
na

-- 
You are receiving this mail because:
You are the assignee for the bug.

Reply via email to