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#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]
---------------------------------------------------------------------
To unsubscribe, e-mail: [EMAIL PROTECTED]
For additional commands, e-mail: [EMAIL PROTECTED]
