To comment on the following update, log in, then open the issue: http://www.openoffice.org/issues/show_bug.cgi?id=98505
------- Additional comments from [email protected] Tue Jan 27 11:01:31 +0000 2009 ------- anwyl42: You need to use array functions to accomplish your examples. {=B5:B15*C5:C15}, the braces are created when you use Ctrl Shift Enter to enter the array function to give the output array.(Which is created automatically.) If you need a sum of the product just use the "SumProduct" function. Also, you can name your different data areas and use them in the array formula . Eg. {=UnitsP*UnitV/TimeP}. Attached a sample sheet. TomW --------------------------------------------------------------------- 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]
