https://bugs.documentfoundation.org/show_bug.cgi?id=98756
Bug ID: 98756
Summary: Editing: SUM(IF(MONTH($A$2:$A$366)=E4;$B$2:$B$366;0))
giving wrong result
Product: LibreOffice
Version: unspecified
Hardware: All
OS: All
Status: UNCONFIRMED
Severity: normal
Priority: medium
Component: Calc
Assignee: [email protected]
Reporter: [email protected]
Created attachment 123699
--> https://bugs.documentfoundation.org/attachment.cgi?id=123699&action=edit
document demonstrating wrong behaviour
Hi!
During the trial and error I found that something is wrong with the construct:
=SUM(IF(MONTH($A$2:$A$366)=1;$B$2:$B$366;0))
I have the dates from the 1st of Jan to 31 of Dec, I can't get the right
results (for the test - the right count of the days - the construct sums
everything in the range for the month value=1, for other values the result is
zero) - see attachment.
Janis
--
You are receiving this mail because:
You are the assignee for the bug.
_______________________________________________
Libreoffice-bugs mailing list
[email protected]
https://lists.freedesktop.org/mailman/listinfo/libreoffice-bugs
