https://bugs.documentfoundation.org/show_bug.cgi?id=170144
Bug ID: 170144
Summary: Help: wrong example for SUMIF
Product: LibreOffice
Version: 25.8.3.2 release
Hardware: All
OS: Windows (All)
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
The second example is incorrect (wrong column specifications):
=SUMIF(B2:B5;">=20";C2:C6)
Sums values from the range B2:B6 only if the corresponding values in the range
A1:A5 are >=20. Returns 340 because the fifth and sixth rows do not meet the
criterion.
The correct text should be;
Sums values from the range C2:C6 only if the corresponding values in the range
B1:B5 are >=20. Returns 340 because the fifth and sixth rows do not meet the
criterion.
--
You are receiving this mail because:
You are the assignee for the bug.
