To comment on the following update, log in, then open the issue:
http://www.openoffice.org/issues/show_bug.cgi?id=82104
User fst changed the following:
What |Old value |New value
================================================================================
Status|UNCONFIRMED |RESOLVED
--------------------------------------------------------------------------------
Resolution| |INVALID
--------------------------------------------------------------------------------
------- Additional comments from [EMAIL PROTECTED] Mon Oct 1 09:27:41 +0000
2007 -------
Hi,
not a bug of Calc but misconfigured named ranges.
With SUMIF the ranges for Range and Sum Range must be equal in size to give
correct results. If they are not equal in size a summation can't give a result
as either the range or the summation range is to short. in your case WhoPaid is
smaller as AmmountPaid $Sheet1.$C$7:$C$65358 and $Sheet1.$D$2:$D$65358. the
named range Who_Paid ist defined with the same size as AmountPaid
$Sheet1.$C$2:$C$65358 and $Sheet1.$D$2:$D$65358.
So this is not a defect and invalid. I close it as such.
Frank
---------------------------------------------------------------------
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]
