I find the method awkward enough already. I have all the criteria ranges in the same part of the document and never need to see them. All you're trying to achieve is not repeating the first row of the first criterion range. I doubt that the programmers have been so obliging as to enable you to do that.
If you want to use range names for the criteria ranges, Insert >Names >Define seems not to permit naming disjunctive ranges. Joshua Simons wrote: > > My understanding is that a criteria specification containing multiple > rows will OR together the criteria and that's not what I need. I have a > set of criteria that I want to evaluate separately against the same > database > using separate DAVERAGEs(). Rather than creating the following rows: > > column headings | this is the criteria specification for my > criteria #1 | first use of DAVERAGE(). > column headings | this is the criteria for the 2nd > criteria #2 > column headings | and for the 3rd. > criteria #3 > (etc) > > > I'd like to list the headings only once and then specify the > criteria ranges using that heading row paired with each > of the criteria rows. To do that, I need to specify the criteria > range as two non-contiguous rows. > > On Feb 7, 2007, at 7:10 PM, TerryJ wrote: > >> >> >> 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#a8860189 Sent from the openoffice - users mailing list archive at Nabble.com. --------------------------------------------------------------------- To unsubscribe, e-mail: [EMAIL PROTECTED] For additional commands, e-mail: [EMAIL PROTECTED]
