To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=63166
Issue #:|63166
Summary:|Summing multiple columns in Matrix formula doesn't
|work
Component:|Spreadsheet
Version:|OOo 2.0
Platform:|Sun
URL:|
OS/Version:|Solaris
Status:|UNCONFIRMED
Status whiteboard:|
Keywords:|
Resolution:|
Issue type:|DEFECT
Priority:|P3
Subcomponent:|code
Assigned to:|spreadsheet
Reported by:|mmusterd
------- Additional comments from [EMAIL PROTECTED] Tue Mar 14 06:52:05 -0800
2006 -------
I try to sum a range inside a long table if the date matches a certain
criterium.
Say I have one column with the dates, and I am interested in the sum of the
numbers Num1 and Num2 of all dates in a certain month.
Now the matrix selector does work, but only the data in the first column is
added; the other(s) is ignored.
EXAMPLE:
--------
Date Num1 Num2
01/01/06 4 5
01/02/06 4 5
01/03/06 4 5
01/04/06 4 5
01/05/06 4 5
01/06/06 4 5
01/07/06 4 5
01/08/06 4 5
01/09/06 4 5
01/10/06 4 5
01/11/06 4 5
01/12/06 4 5
01/13/06 4 5
01/14/06 4 5
01/15/06 4 5
01/16/06 4 5
01/17/06 4 5
01/18/06 4 5
01/19/06 4 5
01/20/06 4 5
01/21/06 4 5
01/22/06 4 5
01/23/06 4 5
01/24/06 4 5
01/25/06 4 5
01/26/06 4 5
01/27/06 4 5
01/28/06 4 5
01/29/06 4 5
01/30/06 4 5
01/31/06 4 5
02/01/06 4 5
02/02/06 4 5
02/03/06 4 5
02/04/06 4 5
02/05/06 4 5
02/06/06 4 5
Cell A40 contains 1 feb 2006
I can then insert the formula
{SUM(IF(MONTH(A40)=MONTH(A1:A37);B1:C37))}
and the result is 24, instead of the expected 54.
I can also do
{SUM(IF(MONTH(A40)=MONTH(A1:A37);B1:B37))} (24)
{SUM(IF(MONTH(A40)=MONTH(A1:A37);C1:C37))} (30)
so the principle of the function seems to work, however the adjacent column is
not added at all.
In MS excel it works fine, so there does not appear to be a bug in my logic..
:-)
---------------------------------------------------------------------
Please do not reply to this automatically generated notification from
Issue Tracker. Please log onto the website and enter your comments.
http://qa.openoffice.org/issue_handling/project_issues.html#notification
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
