Joshua Simons wrote: > > > Is it possible to specify non-contiguous cell-ranges in OO under Mac > OS X? > > In particular, I would like to specify a non-contiguous range for the > 3rd > argument to DAVERAGE()... > > Josh Simons > >
The third argument is a range which contains your criteria. It has to mirror the range containing the values you wish to average. Here is an example of a criteria range I use for DAVERAGE: DATE HIGH LOW CLOSE OPEN VOL MOVE VALUE >=07/11/2006 The first row contains the column headings of the range containing values. The second row contains criteria. Subsequent rows contain sets of alternative criteria. The criteria range is critDateCalcs. Part of a typical formula using the criteria is =DAVERAGE(BTVdly;"VALUE";critDateCalcs) That finds the average of values in the column VALUE in the table BTVdly which occur on and after the date 7/11/6 in the DATE column of the table. (The date in the criteria range is calculated by a formula.) Regards. -- View this message in context: http://www.nabble.com/Entering-non-contiguous-ranges-in-Calc-tf3190506.html#a8857250 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
