To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=110108 Issue #|110108 Summary|sumif function - latest calc version Component|Spreadsheet Version|1.0.3 Platform|All URL| OS/Version|All Status|UNCONFIRMED Status whiteboard| Keywords| Resolution| Issue type|DEFECT Priority|P1 Subcomponent|programming Assigned to|spreadsheet Reported by|ericotavares
------- Additional comments from ericotava...@openoffice.org Sun Mar 14 02:04:17 +0000 2010 ------- Hello, The built-in SUMIF function has a quirk, which would be great if yo could fix. Here's the formula: Let's assume we type the following formula in cell E9 SUMIF(C2:C9 ; ">"&F2 ; D2:D9) The issue is that when you copy the formula downwards, the middle part - “>"&F2 - never changes. Therefore, is it possible to update the function such that when you copy it down or right, the reference cell F2 changes accordingly? You can always have the cell fixed with the $ signs, like in other calc functions. Thanks you Erico --------------------------------------------------------------------- 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: issues-unsubscr...@sc.openoffice.org For additional commands, e-mail: issues-h...@sc.openoffice.org --------------------------------------------------------------------- To unsubscribe, e-mail: allbugs-unsubscr...@openoffice.org For additional commands, e-mail: allbugs-h...@openoffice.org