To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=95144
------- Additional comments from t...@openoffice.org Sat Nov 7 18:32:37 +0000 2009 ------- I have a document in Excel 2007 which has a lot of SUMIFS. Is there a way around this not working by restating the formula in a way which Calc understands? Example: =sumifs($H$4:$H$506;$A$4:$A$506;">=11/1/09";$A$4:$A$506;"<=11/30/09") Thank you --------------------------------------------------------------------- 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