https://bugs.documentfoundation.org/show_bug.cgi?id=164607
Bug ID: 164607
Summary: SUMIF doesn't count multi columns
Product: LibreOffice
Version: 24.8.4.2 release
Hardware: x86 (IA32)
OS: other
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Description:
Using the SUMIF functions specifying 2 columns next to each other in the sum
range, it doesn't sum-up all the selected columns, only the 1st one.
for example:
dec 2 0
dec 0 1
nov 1 0
dec 2 0
=SUMIF(A2:A5,A7, B2:C5)
dec 5
the correct answer is 6 instead of 5
Steps to Reproduce:
1.use SUMIF fx
2.enter range and criteria
3.in sum range enter at least 2 columns (i.g. in cell E7 =SUMIF(A:A,D7,B:C)
Actual Results:
It sums only column B
Expected Results:
sum column B and C
Reproducible: Always
User Profile Reset: No
Additional Info:
Version: 24.8.4.2 (X86_64) / LibreOffice Community
Build ID: bb3cfa12c7b1bf994ecc5649a80400d06cd71002
CPU threads: 2; OS: Linux 6.5; UI render: default; VCL: gtk3
Locale: en-GB (en_GB.UTF-8); UI: en-GB
Flatpak
Calc: threaded
--
You are receiving this mail because:
You are the assignee for the bug.
