Stating ranges in formulae
Not knowing what you are trying to do, you can also use a single criteria
range and have formulas in the criteria cells which "calculate" your
criteria, perhaps based on some input cells.
But glad you found a solution.
--
Regards,
Tom Ogilvy
"Steven Revell" wrote in message
...
I worked around it using a table with named ranges in and
used the lookup to decide which named range to choose.
DAVERAGE($A$7:$J$42,4,INDIRECT(VLOOKUP(LEFT($B10,L EN($B10)-
2),CritRange,2,FALSE))
indirect takes the text name of the named range and
returns it as a range.
-----Original Message-----
criteria requires a range.
--
Regards,
Tom Ogilvy
"Steven Revell" wrote in
message
...
Hi,
I was wondering if it possible to state formula in the
following way, i can't figure out how to do it myself
but
its along these lines:
DSTDEV(database,field,criteria)
DSTEV(A5:J50,4,array("Code","F0.01"))
I want to specify the criteria myself as opposed to
stating a range. Is it possible or... is possible to
state
the formula as:
DSTEV(A5:J50,4,array(A1,C3))
Thanks for any help,
Steven
.
|